We are reading .csv file which has multiple new-line character in multiple columns. I tried different options to read these records, but still the records are getting rejected.
Below are the option I tired.. but no luck
In the Format tab
In the Record level
1. changed the final delimiter to '\n', end, none,null
2. Add the record delimiter string = Dos format
In the Field defaults
1. Add the delimiter string chr(10), char(13)
2. Removed double quotes add it back
Our data file is :
Code: Select all
"ID" , "Comments", "Modified_date","Modified by"
"1", " THIS iS
BIG COMMENT
AND BIG VALUE","2013-09-20T05:00:00Z" ," TESTER" --------> record 1
"2",
"<div><font face="Calibri" size="2" color="black">#nllsd some big value
and
more value
","2015-09-20T05:00:00Z" ," TESTER1" --------> record 2
Appreciate all your help!!
Thanks in advance