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]

Not able to see the attached. please upload it again. or you can attached the same line(including split) as file to the post.

[Anonymous]

Hi Tulasi,

Did you get any login issue? We saw that you posted your issue as "Guest".

Best regards
Sabrina

[Anonymous]

Hi Umesh,
Sorry for the inconvenience,Please find attached the screen shot.

[Anonymous]

Hi Tulsi, 
By looking at your file i am unable to find what is the problem, but I would like to suggest that use below code to replace multiple Tab spaces, e. g. if your line contains more than 1 tabs then replace with {2} if it contains more than that then use multiple replace statements on same line. check for below solution. 

String foo = "bar	1		2			3";
System.out.println(foo.replaceAll("\\t{2}","	").replaceAll("\\t{2}","	"));

or you can use below statement regardless of Tab, space, empty value & new line as well. 

System.out.println(foo.replaceAll("\\s+","	"));

hope this will work for you..

[Anonymous]

Hi Umesh,
Where should i use this code.
Currently i am using it in tjavaRow.
The actual problem is the row that i have showed here is a single line and due to the tabs spaces the row got split into 2 line and the number field is taking the string field in the second row and the issue For Input String : "MANJUNATH" is displayed. as shown in the screen shot.

[Anonymous]

try below flow 
tFileInputFullRow--tJavaRow--tMap--tExtractDelimitedField---yourOutput. 
you will get "line" column in tFileInputFullRow. 
use mention code in tJavaRow 

output_row.line=input_row.line.replaceAll("\\s+","	");

rest of the things need to modify as per requirement.