Skip to Content
0
Former Member
Jan 20, 2012 at 12:41 AM

Embedded new lines in CSV file

123 Views

Hi,

We have a series of CSV files which contain a comment field. This is free-form text, and thus can contain new lines, etc..

Our legacy solution (base on SSIS) can't handle that, so a script removes the newlines. Do we need to do this with Data Services ? The fields are quoted, so will DS continue onto the next line looking for the end of the field ?

It would be preferable to preserve the newlines, as sometimes it is significant.

Secondly, every field in quoted in the file including the header line. When I set the text delimiter, it works for the records, but not for the header. The only way I have found to fix this is to manually edit the headers. Is there another way to do this ?

Thanks.