Line terminator issue in tFileOutputDelimeted component

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[cmendels]

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!

[Anonymous]

I could not see any options to select LF here.

[Anonymous]

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

[cmendels]

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

[Anonymous]

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

Thanks,

Meghana

[Anonymous]

@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

[Anonymous]

Here it is.. I have attached configuration

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