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?
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.
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.
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.
|Powered by Social Strata|