Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

.CSV to .txt using SFTP Adapter

Hi All,

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.



replied

Hi Vishnu

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)

ParameterValue
xml.endSeparator!##!'nl'

As for the header line, you can configure the following

ParameterHeader 2
xml.addHeaderLine3
xml.headerLineORG_ID,STUD_ID

You can refer to the following if you want to understand further

FCC parameter reference for MessageTransformBean module

Converting XML in the Receiver File/FTP Adapter to Text Format - Advanced Adapter Engine - SAP Library

Rgds

Eng Swee

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question