I am trying to import a cvs file that has a field that has double quotes embedded in the text as shown below:
I need a way to covert the double quotes to a single quote so the result would look like:
I tried using the REPLACE(…) function but cannot figure our how to get a single quote back in. No matter what I try I end up with the double quote.
I need to append approximately 100 records per day so I need a good method to update the information in this field after the records are appended to the master file.