topic Re: Line terminator issue in tFileOutputDelimeted component in Talend Studio

Line terminator issue in tFileOutputDelimeted component

Anonymous — Sat, 16 Nov 2024 07:25:47 GMT

Hi,

I wanted to extract query result to a csv file with LF as line terminator. I have used "\n" as Line terminator in tFileOutputDelimeted component and I am getting CRLF as line terminator.

I have tried with \n, \r, \n\r, \r\n. In all cases, I am getting CRLF as line terminator.

Can anyone help me out?

Thanks in advance,

Meghana

Re: Line terminator issue in tFileOutputDelimeted component

Anonymous — Mon, 22 Oct 2018 14:16:07 GMT

Thats weird. One possible issue could be that if you are using git as your repository you may have autocrlf turned on.

Double check your git settings ( "git config --global --edit" from the commandline) to see if you have core.autocrlf set to true

Re: Line terminator issue in tFileOutputDelimeted component

Anonymous — Tue, 23 Oct 2018 08:08:14 GMT

Thanks for your response, but I haven't using git repository.

Re: Line terminator issue in tFileOutputDelimeted component

cmendels — Wed, 31 Oct 2018 14:51:35 GMT

My coworker just had the opposite problem - she needed CRLF, but was just getting LF.

Do you have the csv options box checked on the Advanced Settings tab? If not, try that and select LF. If so, try unchecking the Use OS line separator box.

Hope this helps!

Re: Line terminator issue in tFileOutputDelimeted component

Anonymous — Thu, 01 Nov 2018 05:44:22 GMT

I could not see any options to select LF here.

Re: Line terminator issue in tFileOutputDelimeted component

Anonymous — Thu, 01 Nov 2018 07:13:37 GMT

Hi,

I was able to add the line separator of my choice (\r OR \n OR \r\n) in the tfileoutputdelimited. You need to use the row separator in the basic settings to modify the same. Please refer the screenshots below.

a) Scenario A - Only with Carriage return

a) Scenario B - With Carriage return and Line Feed

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: Line terminator issue in tFileOutputDelimeted component

cmendels — Thu, 01 Nov 2018 21:02:14 GMT

The option to choose LF is in the basic settings after you have checked the csv options box in the advanced settings.

Re: Line terminator issue in tFileOutputDelimeted component

Anonymous — Fri, 02 Nov 2018 07:38:20 GMT

I have checked the box LF too. I don't know why I am getting my output as CRLF

Thanks,

Meghana

Re: Line terminator issue in tFileOutputDelimeted component

Anonymous — Fri, 02 Nov 2018 08:00:00 GMT

@MeghanaKottala - Could you please share the component basic screen shot and if possible can you add a zip file export of your job for detailed analysis?

Warm Regards,

Nikhil Thampi

Re: Line terminator issue in tFileOutputDelimeted component

Anonymous — Fri, 02 Nov 2018 10:25:45 GMT

Here it is.. I have attached configuration

Screen Shot 2018-11-02 at 3.55.04 PM.png

Re: Line terminator issue in tFileOutputDelimeted component

Anonymous — Fri, 02 Nov 2018 11:06:36 GMT

Hi,

It is correct configuration and the file should have only Line feed. Hope you are opening in a normal text editor like Notepad++ and seeing the results.

If you open the file with some other application (like excel) and while closing the file, it may prompt you to save. The moment you save from within windows, it will be replaced by CRLF since it is the default Windows line break. The tool should be working as per the expectations in this scenario.

If the error persists, could you please create a support case and they can help you remotely real time? You can also share the details of this community so that turnaround time will be lot quicker.

Warm Regards,

Nikhil Thampi