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 !
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 firstname.lastname@example.org
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.