Subustituting

[kiwiora]

Hi,

I export my data to merge with word (.mer file). As such " is a field delimiter and I am trying to use the substitute command to replace double quotes with single i.e

Substitute(claimdescription; "[color:RED]""; "[color:red]'")

This won't work. Does anyone have a work around?

TIA

[Vaughan]

Do you mean that some fields in the database contain double-quote characters?

This shouldn't be a problem because the export format can cope with double quotes (and commas as well). When Word processes the export file it should sort it all out.

I recently had a client that was working with merge files as well, a system that I built for them a couple of years ago. When they opened the files in Excel it alooked like it had all gone wrong.

Solution: don't open export files in Excel. It converts files without prompting.