COPY command to handle carriage returns?

Moderator: NorbertKrupa

Post Reply
debfawn
Beginner
Beginner
Posts: 47
Joined: Tue Jan 29, 2013 2:30 pm

COPY command to handle carriage returns?

Post by debfawn » Thu Sep 08, 2016 12:29 pm

Hi gurus...

Anyone have a COPY command solution that can handle data that has carriage returns in the data? We have a CSV file where one of the fields has doctor's notes (i.e. even ones myself have written) full of carriage returns... We tried enclosing the fields with quotes, but that did not work.

Thanks in advance!

Post Reply

Return to “Vertica SQL”