Skip to Content

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

Flat File to Flat File

Hi,

I am doing an interface (Flat file to Flat file)

The input file fields are separated by delimiter @!.Which will have multiple records like LEVEL1,LEVEL2,LEVEL3

Input Flat file

Level1@!PoNo@!ShortText@!StDate@!EndDt@!Vendor@!Status

Level2@!PoNo@!L2id@!L2desc@!L2stdt@!L2ensdt@!L2plant@!order

Level3@!PoNo@!L2id@!L3id@!L3stdt@!L3enddt@!order

Level1@!PoNo@!ShortText@!StDate@!EndDt@!Vendor@!Status

Level2@!PoNo@!L2id@!L2desc@!L2stdt@!L2ensdt@!L2plant@!order

Level3@!PoNo@!L2id@!L3id@!L3stdt@!L3enddt@!order

Level1@!PoNo@!ShortText@!StDate@!EndDt@!Vendor@!Status

Level2@!PoNo@!L2id@!L2desc@!L2stdt@!L2ensdt@!L2plant@!order

Level3@!PoNo@!L2id@!L3id@!L3stdt@!L3enddt@!order

-

-

-

Output file

The outfile fields are separated by tab delimiter

<L1> L1Pono L1desc L1stdt L1enddt L1hr L1cost L1vendor L1misc L1status

<L2> L1Pono L2ID L2desc L2stdt L2enddt L2priority L2loc L2plant L2order

<L3> L1Pono L2ID L3ID L3desc L3stdt L3enddt L3work L3emp L3order

The outfile fields are separated by tab delimiter

<L1> L1Pono L1desc L1stdt L1enddt L1hr L1cost L1vendor L1misc L1status

<L2> L1Pono L2ID L2desc L2stdt L2enddt L2priority L2loc L2plant L2order

<L3> L1Pono L2ID L3ID L3desc L3stdt L3enddt L3work L3emp L3order

-

-

-

Do I need to use file content conversion?how do I replace the delimiter?

Can you please tell me how to do this,appreciate you help.Let me know if you need more info.

Points will bw rewarded

Thanks

Former Member

Helpful Answer

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