Issue with newline character in exported rows

Home › Forums › Data Pipeline Toolkit Forums › Data Pipeline Toolkit – Help › Issue with newline character in exported rows

Tagged: 

This topic has 3 voices, contains 2 replies, and was last updated by  nick c 157 days ago.

Viewing 3 posts - 1 through 3 (of 3 total)
Author Posts
Author Posts
October 30, 2011 at 7:41 PM #349

powerhealthsolutions

When I export rows coming from the database that contain newline characters, the CSV file contains something like this:

Name,Description,AccountType,AccountRangeStart,AccountRangeEnd
test,”line1
line2″,E,10,10

When I import this using your library, it does not recognize the row should be continued on the next line.

Is there a suggested solution to this?

Regards
November 8, 2011 at 9:14 PM #350

Dele Taylor

Hi,

You can read the file in by first calling setAllowMultiLineText(true) on your CSVReader.

Cheers,
Dele
December 13, 2011 at 9:54 PM #378

nick c

Hi,

What if we are using a validating reader to read a CSV file?

Regards,
Nick
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.