carriage return CSV

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
8 REPLIES
Five Stars

Re: carriage return CSV

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

Re: carriage return CSV

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 
Five Stars

Re: carriage return CSV

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

 
Five Stars

Re: carriage return CSV

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

 
Five Stars

Re: carriage return CSV

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

 
Five Stars

Re: carriage return CSV

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
Five Stars

Re: carriage return CSV

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 propertiesSmiley Frustratedtring 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. 
Five Stars

Re: carriage return CSV

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