topic Export as csv file without Escape char causes issue with row separator in Talend Studio

Export as csv file without Escape char causes issue with row separator

Anonymous — Sat, 16 Nov 2024 11:59:02 GMT

Hi experts,
I receive an error when creating the FileDelimitedOutput as a .csv file. I only get the error if I disable CSV options (Component > Advanced settings > CSV options).
The reason I want to disable the CSV options is because I need the output data to appear without the "" around each row item. Is it possible to remove the """ escape char option without causing the output to fail?
The error I get at the moment: The method CRLF(String) is undefined for the CustomerMerge
The file needs to be in csv format but without the "" on each field. Is this possible?
Many thanks

Re: Export as csv file without Escape char causes issue with row separator

Anonymous — Thu, 04 Jul 2013 08:24:15 GMT

Hi,
What's your input source, could you please elaborate your case with an example with input and expected output values?
Actually, you can use meta data from repository "File Delimited" to set the input source.
See the related forum https://community.talend.com/t5/Design-and-Development/FileInputDelimited-not-removing-quotes/td-p/111747
Best regards
Sabrina

Re: Export as csv file without Escape char causes issue with row separator

Anonymous — Mon, 15 Jul 2013 04:24:04 GMT

Sorry I have this working ok now. I wanted to log in earlier to update but I have not been able to for some reason. However you need to manually remove the CRLF and enter "\r\n" instead.

Re: Export as csv file without Escape char causes issue with row separator

Anonymous — Mon, 15 Jul 2013 04:55:27 GMT

Hi,
Thanks for your feedback. I will make investigation on it.
Best regards
Sabrina