Loading CSV file which have new line with blank columns

[Anonymous]

Hi,
I have CSV file which has a new line in middle of the column and the rest of the data in that row has gone to next line.
because of which i am facing issue while loading the data into DB.
please see the below screen shot.
I need to remove the spaces after column with data "MANJUN" and append the rest of the data after it.


Thanks,
Tulasi

[Anonymous]

Hi,
You screenshot is missing. Please make sure that y our file must not be bigger than 2 MB.
Is it OK with you when check out "Trim" option  in tfileinputdelimited to  trim the leading and trailing white space?

Best regards
Sabrina

[Anonymous]

Hi Sabrina,
I am attaching the screenshot.
Yeah, i have tried it with the Trim Option, but no luck.
Thanks,
Tulasi

[Anonymous]

 
Screen shot uploaded

[Anonymous]

screenshot for reference.

[Anonymous]

i am unable to upload the screen shot.
Can you please me without the screen shot

[Anonymous]

select check csv options in advance tab of tFileInputDelimited. if your file has string data enclosed with double quotes.

[Anonymous]

Hi Umesh,
There are no string data in my csv file enclosed in double quotes.
There is a complete blank line after the first two columns and the next line contains the data.
Thanks,
Tulasi

[Anonymous]

Can you show us, source row or paste the raw row here?

[Anonymous]

Thanks,
Tulasi