[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Eliminate chart's



as the other guys say, you can do the ltrim and rtrims with ' '.  

Say you're unstringing the line by ',', just take each section, ltrim,
rtrim, and remember to do a check to see if it's null after the trims.  

(if ltrim(rtrim($var,' '),' ') = ''  
   do something_to_handle_all_spaces
 end-if)


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Eduardo_Bugarin@hdm.honda.com
Sent: Friday, November 12, 2004 12:28 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Eliminate chart's


Hello all

I read a text file but some fields has some characters nulls
for example:

180D     ,TEST, TEST2      ,ETC,ETC,ETC

do you know any command to get only the 180D or TEST2 without charecters
nulls ????????

thank you for your help



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users