10-27-2011 12:34 PM
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.
10-27-2011 12:44 PM
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.
10-27-2011 12:50 PM
Need further help from the community? Please ask a new question.