FTP Adapter Write operation is not recognising new line character

Summary

issue to convert a .txt file delimited by pipes in a .csv file without pipes and order by columns

Content

Hi All,

I have a requirement to read txt file delimited by pipe '|' from FTP server and send data in csv format to other system using ICS with FTP Adapter, the text for the csv file must be transformed to remove the pipe '|' and separate it by rows and columns according to the order.

I have tried in some ways but all records are stored in a single cell and so far I have not been successful.