topic Re: Some Problems with CRLF in CSV in Talend Studio

Some Problems with CRLF in CSV

Anonymous — Sat, 16 Nov 2024 10:57:28 GMT

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.

Re: Some Problems with CRLF in CSV

Anonymous — Tue, 10 Nov 2015 08:29:25 GMT

deleted

Re: Some Problems with CRLF in CSV

Anonymous — Tue, 10 Nov 2015 22:36:07 GMT

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

Re: Some Problems with CRLF in CSV

Anonymous — Thu, 12 Nov 2015 08:54:17 GMT

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

Re: Some Problems with CRLF in CSV

Anonymous — Fri, 13 Nov 2015 14:36:39 GMT

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

Re: Some Problems with CRLF in CSV

Anonymous — Thu, 19 Nov 2015 14:42:52 GMT

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