[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
- Subject: RE: [sqr-users] Eliminate chart's
- From: Bob Stone <bstone@fastenal.com>
- Date: Fri, 12 Nov 2004 13:09:15 -0600
- Delivery-date: Fri, 12 Nov 2004 14:14:58 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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