Substituting a ' not working :(

[Jalz]

Hi Guys,

Im writing a module to export some data into an accounts package. Im trying to clear certain fields of "illegal" characters, before my records are exported as a CSV file.

I am using the substitute command to clear away symbols like !,",

[-Queue-]

Go to Edit -> Preferences -> Document and deselect 'Use smart quotes'.

[Lee Smith]

Or,

If that doesn't do it, capture one of the apostrophe that are not being removed, and paste that into your Substitute calculation.

Lee