07-22-2015 10:52 AM
This is my first post so apologies if it is in the wrong place or incorrect in some way.
I assigned a libname to an excel workbook like this:
libname temp EXCEL "&workbook." dbmax_text=32767 getnames = no;
Some variables have large spaces in their values due to the fact that once cell in my excel workbook may have multiple lines split apart by some kind of newline character.
I removed these using the following code in a datastep:
However I was wondering if anyone knew a specific string of characters I could search for as it would help me achieve my programming goal - I want to replace these characters with a space.
I hope someone can help
P.S. I use windows
07-24-2015 01:34 PM
You may find the NOTPRINT function helpful. You can find the location of non-printing characters and replace them with blanks.
There are also other threads on this forum for the same issue.