Some Problems with CRLF in CSV

[Anonymous]

Hello everybody 

I tried to make an input operation from an CSV Files which comes from an Oracle Database to an Salesforce Account.

Unfortunately the csv contains a lot broken lines (i think it will be called cr and lf's).  
Here is some example which describes the problem ( some places are distorted ).

I think about an tReplace object to solve this but this is my first talend job and i'm not so familar with java.

Maybe somenone could bring on the right way 


The Picture from the csv and the talend job  are Attached 

best regards 



john s. 



And in this way should the csv look like:



thanks for help 

best regards john s. 

[Anonymous]

deleted

[Anonymous]

Hi fireskyer

Please look at this forum   https://community.talend.com/t5/Design-and-Development/carriage-return-CSV/m-p/74280

Best regards,

Alfonso Borré
Skype : alfonso.borre
aborresarmiento@yahoo.es

[Anonymous]

Hello ingenioso
I've followed your instruction in your Thread .. and it comes this error:

Exception in thread "main" java.lang.Error: Unresolved compilation problems: 
	input_row cannot be resolved to a variable
	output_row cannot be resolved to a variable

What does it mean ? .. Do i have oversee something  with my plenty knowledge ?

best regards fireskyer 

[Anonymous]

Hi fireskyer
I did respond your comment in the other post.

Please change tJava by tJavaRow

Best regards,

Alfonso Borre
skype : alfonso.borre
aborresarmiento@yahoo.es

[Anonymous]

Update

I'm sick with the csv conversitions...

I got the Permission to Access  Directly to database and  everything is fine 

Thanks all  for helping 

regards john