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

Re: Space and Tab - in flat file



Try this:

let $tab = chr(09)
let $whatever = ltrim($whatever, $tab)

It should work, but I didn't try it.

-----------------------------------------------------
Jamie Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> parthiban@IWON.COM 10/2/2002 5:32:29 PM >>>
 Hi all, I am trying to read a file which has leading tabs and spaces.
Using ltrim function I amable to l-trim spaces, not tabs. How to Ltrim
tabs?..I can write a code to do the same, but like to know if SQR
function can do that.. Thanks,Parthiban Subbiah

------------------------------------------------
Changed your e-mail?  Keep your contacts!  Use this free e-mail change
of address service from Return Path.  Register now!
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Harris, Jamie
TEL;WORK:2668
ORG:Work;Division of Information Technology
EMAIL;WORK;PREF:JHarris@frederick.edu
N:Harris;Jamie
TITLE:Systems Analyst, PeopleSoft
ADR;DOM;WORK;PARCEL;POSTAL:;L-205
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Harris, Jamie=0A=
L-205
END:VCARD