Parsing double quotes out of sqlldr control file replace statement
Posted on 2008-10-17
I have an SQLLDR control file where fieldA that is going into the DB at times contains a double quote. I have tried to parse out the " in the following way:
fieldA "replace(:fieldA, '\"'', '\\\"'')",
This is attempting to take every instance of " in the incoming file and replace it with \" to allow the double quote to be put into the database. This runs without error, but the quotes are still causing problems upon insert, so the replacement isn't working right.
How should I modify this statement in order to allow the double quote in the input file field to be put into the DB?