.CSV to .txt using SFTP Adapter
I have requirement where I need to pick .csv file and convert it as .txt file using SFTP.
The below are the validations.
1. Must be a pipe separated, .txt file
2. Must have !##! At the end of every line in .txt file.
3. Must be encoded via UTF-8 format.
4. Need to avoid the first line from CSV i.e. function owner and department.
I am attaching source .csv file and expected target .txt file.
Could you please help me on the requirement.
Eng Swee Yeoh replied
Please check the wiki properly for the correct conversion type, you should use the following:-
SimplePlain2XML - sender
SimpleXML2Plain - receiver
To fulfill the end of line requirement, you need the following parameter (need extra 'nl' at the end to have the line break)
As for the header line, you can configure the following
You can refer to the following if you want to understand further