Some of the rows from my Sequential file (csv) are rejecting. The reason CR/LF within the field.
Do you think I can handle this problem by setting up the right properties/format parameter on Format|Record_level.
If it LineFeed (LF) I could handle them by using
Code: Select all
Properies|format (Record delimeterstring = DOS Format)
However, each column/field are double quotes and field delimiter within comma i.e. "aaa","bbbb"
From the following example the 1st row ok but (2,2b) rejecting during load
When I open the file in Notepad++ it show two CR/LF(CarriageReturn/LineFeed) on row 2,2b as shown below:
Code: Select all
"106.5","18.1","15.96","Logmar",,"No",,"Yes",,"Farhan"
"110.3","21","17.26","Logmar
Refer to Optician.",,"No",,"Farhan"
Code: Select all
1--> "106.5","18.1","15.96","Logmar",,"No",,"Yes",,"Farhan" CR|LF
2--> "110.3","21","17.26","Logmar CR|LF
2b-> Refer to Optician.",,"No",,"Farhan" CR|LF
From the above example (2) and (2b) rows should be one row like (1)Note: From above Example : CR|LF is not the value its show the row qualifier (CarriageReturn/Line Feed
The properites I tried on Format tab for "RecordLevel" are:
Code: Select all
Final delimeter = null
Record delimeter = UNIX newline
Code: Select all
Final delimeter String "Farhan"
Kind regards,
Farhan