topic Re: Change newline in FileOutputDelimited to CRLF in Talend Studio

Change newline in FileOutputDelimited to CRLF

Anonymous — Sat, 16 Nov 2024 13:52:02 GMT

Hi!
How can I change the newline in FileOutputDelimited to CRLF?
It only uses a CHAR, though it accepts a string but then ignores everything but the first sign!
Ideas?
TIA
Andre

Re: Change newline in FileOutputDelimited to CRLF

Anonymous — Fri, 17 Jul 2009 22:17:23 GMT

Hi Andre,
use "\r\n" instead.
Bye
Volker

Re: Change newline in FileOutputDelimited to CRLF

Anonymous — Mon, 20 Jul 2009 07:31:49 GMT

Hi,
I can't! As I wrote - admittedly not too clearly - csvwriter ignores everything but the first character as a newline, since it manages the newline internally as a "char"-datatyped value. No String possible here!
If one would be able to not define the value in the component (which is not possible, as the property is required) the csvwriter instance of the component would use the system property "line.separator" as a newline. But changing this is not what I want! It is anything but a feasible workaround.
More ideas? currently I sent the generated file to an external converter tool. ugly
TIA
Andre

Re: Change newline in FileOutputDelimited to CRLF

Anonymous — Mon, 20 Jul 2009 21:03:46 GMT

Hi Andre,
which version are you using. I took a look at the 3.1.3 code and for me it looks like the row separator is defined as TEXT in the xml-definition-file and handled as String in the code.
And default value is "\n" a String too.
Bye
Volker

Re: Change newline in FileOutputDelimited to CRLF

Anonymous — Tue, 21 Jul 2009 09:01:05 GMT

The property is a string, but internally it uses a class named CSVWriter, which only uses a char as the line separator.

Re: Change newline in FileOutputDelimited to CRLF

Anonymous — Tue, 21 Jul 2009 18:20:17 GMT

@ORBIT_Andre
Have you tried it?
The underlying code just appends the line separator to the end of the current row, so any string is valid.