Focal Point
How do I get rid of trailing blank spaces?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6941077331

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
mgrackin
What 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. Cool
March 29, 2004, 02:40 PM
susannah
hey 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.