Compress special characters

[GreggB]

I'm trying to compress all special characters out of street addresses.  It won't allow me to compress #.  When  I take it out of the statement, it does allow me to compress the periods.  I have other characters such as commas and apostrophes I want to get rid of also.

street=upcase(compress(street,'.','#');

[Doc_Duke · Accepted solution]

RTFM.  You have the syntax wrong.

street=upcase(compress(street,'.#');

[ballardw]

Put all of the characters to compress within one set of quotes. The comma between them as you have is trying to interpret the # as a modifier.

street=upcase(compress(street,'.#');

[GreggB]

Excellent.  Thank you.

[art297]

You might find it even easier if you just KEEP the characters you want.  e.g.,

n or N

adds digits, the underscore character, and English letters to the list of characters. thus street=compress(street,,'kn) might accomplish everything you want

[GreggB]

Cool.  That's good to know.