remove blank space before punctuation

[teamssc]

I have a Crystal XI report that is pulling data from a MSSQL database. One of the fields, that is a memo field, has data typed in all CAPS. If there is a punctuation mark in the data then Crystal puts a space before the punctuation mark. I need to take that space out. I'm not really sure what is adding it.

Any help would be appreciated.

 

[lbass]

Since you probably don't want to remove ALL spaces, try the following, adding in punctuation marks as necessary:

replace(replace(replace({table.memo}," ,",",")," .",".")," ;",";") //etc.

-LB