kiwiora Posted July 19, 2007 Share Posted July 19, 2007 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 Link to comment Share on other sites More sharing options...
Vaughan Posted July 20, 2007 Share Posted July 20, 2007 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6139 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now