04-23-2013 01:45 PM
I've imported an Excel file, which appears to have imported correctly.
However fields that have the Alt+Enter have a box  in them, and I'd like to replace it with a space instead.
The compress function with "CH" parameters removes them, but I need a space instead.
The solutions I've found indicate saving as CSV instead, but I'd like to modify the data rather than re-import.
I thought about the translate and tranwrd function, but couldn't figure out how to specify my space. I think its "A0"x but not sure how to verify that either.
04-23-2013 04:46 PM
Would be nice if COMPRESS had an option to replace-with-space instead of remove - of course that's what TRANSLATE does, but writing it as
x=compress(x,,'cz'); *where z=replace with space;
would be easier than the translate code when dealing with longer lists of things.
Need further help from the community? Please ask a new question.