Line terminator issue in tFileOutputDelimeted component
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.
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.
