March 26, 2004, 06:29 PM
<matty@time>How do I get rid of trailing blank spaces?
Could have sworn there was a Function or Subroutine for this, but I cant seem to find it.
Better yet, anyone know how to get a comma delimited file WITHOUT the annoying " " around all your data?
Thanks
March 26, 2004, 06:59 PM
mgrackinWhat verison of FOCUS or WebFOCUS are you using? In what context are you trying to trim trailing blanks? In a MODIFY, MAINTAIN, or TABLE? In a HEADER or a COMPUTE? In an & variable? Need more info to help you better.
March 29, 2004, 02:40 PM
susannahhey matt! good to "see" you on fp.
do you mean just the edit soft concat
DEFINE NEWNAME/A32='''' |OLDNAME || '''';
or the TRIM command (using func manual page 4-44)
which can trim from both front and back of a string.
NENAME/A32=TRIM('T',OLDNAME,32,' ',1,NEWNAME);
There's TRIM, STRIP, and SQUEEZ-- all totally great new functions.
and do you mean how to create a csv in another app to be read into wf?? exporting as a csv from excel xp doesn't put quotes around alpha strings.
there are several newer export as csv formats in excel xp. take the first one on the list.