I am trying to moving data from a DB2 database, but some rows has ^M in it.
I am changing the ^M to \r\n, but the \r\n is invoked in the string instead of being functional.
The fields are separated with | and quotes with "
This since there could be , in the data, and I'm using
copy schema.table FROM 'file.txt' DELIMITER as '|' NULL as 'NULL' CSV QUOTE as '"';
Any idea on how I should do to solve this?