Hi,
I am trying to load a csv file that I have been provided by a third party from their system. The file is comma delimited, and the text delimiter is the double quote ( " )
There are certain values that are causing the import to fail where it looks like the output from the source system includes escaped/ switched quotes. This is the value recorded in one field:
"xxx \"xxxxxx xxx.xxx"
ODI using the quote as the text delimiter is terminating the string early and I'm struggling to load it.
The pattern that is causing the failure is ( \" ) without the brackets.
Does anyone have a suggestion to escape the pattern whilst reading the csv? I'm using the standard control append IKM
The obvious solutions are to go back to customer and change their file but it took months to get to this point, or to run a find and replace through the file but this also has the potential to change values that were legitimately correct, i.e. values that included the slash as the final character
"xxxx\"