Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to upload a .txt file and I know there are double quotation marks in several of the columns which is preventing the file from fully uploading. How can I remove the double quotes during the import process? I know it's probably within the Enable Transformation Step, but I can't figure out how to use it. Thanks for any advice.
Use replace(<your_field_name>, chr(34),'') as your_field_name
34 is the ascii code for double quotes.
maybe the no quotes can help you in the load
then use Colin answer
FROM
quot.txt
(txt, codepage is 1252, no labels, delimiter is ',', no quotes);
thanks for this, but I'm not 100% clear. Do I use that replace statement in the script? or do I use it somehow in the Enable Transformation area?