topic Re: carriage return CSV in Talend Studio

carriage return CSV

Anonymous — Sat, 16 Nov 2024 10:58:39 GMT

Hello to all,
I come to you for a little help on a problem that takes my head for quite some time!
I'll try to be fairly clear and precise:
I have a CSV file with some fields of "carriage returns"
Example of CSV file: In red the name of the green line of columns csv file, another line of pink csv file
As we can see the carriage returns or line break put the brothel in the CSV file
When I want to treat my csv file in Talend to clean it by selecting only certain columns it works half as some columns are not met because of this CSV problem.
Do you have a solution to remove these carts Returns with Talend or with a script, because I want to automate these treatments.
Thanks for your help !

Attached File csv !

File.zip.zip

Re: carriage return CSV

Anonymous — Sun, 01 Nov 2015 13:07:31 GMT

Good day
I sent the solution
Best regards,
Alfonso Borre
skype : alfonso.borre
aborresarmiento@yahoo.es

Re: carriage return CSV

Anonymous — Thu, 12 Nov 2015 13:19:32 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: carriage return CSV

Anonymous — Fri, 13 Nov 2015 10:09:50 GMT

I have make the process eveything in which way youve described ... but i came across with this error

Re: carriage return CSV

Anonymous — Fri, 13 Nov 2015 10:13:14 GMT

I have make the process eveything in which way youve described ... but i came across with this error

Re: carriage return CSV

Anonymous — Fri, 13 Nov 2015 10:16:21 GMT

I have make the process eveything in which way youve described ... but i came across with this error

Re: carriage return CSV

Anonymous — Fri, 13 Nov 2015 14:34:31 GMT

Hi fireskyer
You used a wrong component. You should use tJavaRow and you did put a tJava component.
Please change the component and try again
Best regards,
Alfonso Borré
Skype : alfonso.borre
aborresarmiento@yahoo.es

Re: carriage return CSV

Anonymous — Mon, 16 Nov 2015 09:22:48 GMT

Hello Ingnesio
Thanks for helping
So it comes another error but first of all i will show you an example csv which describe the problem.

The Error is: Error in the component's propertiestring literal is not properly closed by a double-quote
I think it has sth. to do that the replace code still does not fit for the csv.
best regards john s.

Re: carriage return CSV

Anonymous — Thu, 19 Nov 2015 14:43:57 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