Question Re: Convert Text file to XML in Technology Q&A

Convert Text file to XML

Former Member — Mon, 10 Jun 2013 05:22:53 GMT

Hello Experts,

I have a requirement to convert text file to XML. The text file is of below format:

Records=2

Rec1=12345.xyz

Rec2=9876.xyz

[Separator]

Rec1=ABCD-4567

Rec2=LMNO-1023

The above file should be converted to below XML:

<Message_Name>

<Node>

</Node>

<Node>

</Node>

</Message_Name>

Please note that there can be any number of records (10/ 50/ 100.....etc).

Any solution to above requirement?

Thank you!

Re: Convert Text file to XML

Dimitri — Mon, 10 Jun 2013 06:27:05 GMT

Dear Pankaj,

Have a look at the file content conversion option in a sender file communication channel.

Kind regards,

Dimitri

Re: Convert Text file to XML

Hil1 — Mon, 10 Jun 2013 07:19:25 GMT

Dear Pankaj,

if you are using the Seeburger-BIC-Adapter for your EDI requirements, you can use it as well for such requirements like CSV-FIle, Text-files...

Otherwise, the Content-Conversion-Option as mentioend by Dimitri should should also be able to do it (if using the File-Adapter).

Kind Regards

Stefan

Re: Convert Text file to XML

Former Member — Mon, 10 Jun 2013 07:31:03 GMT

Hi,

only file content conversion is not enough here. There is no standard for this file format. You need a kind of mapping logic to convert the adapter result to the expected xml.

/Udo

Re: Convert Text file to XML

Former Member — Mon, 10 Jun 2013 08:45:18 GMT

Hi,

You can use message transform bean also:

http://help.sap.com/saphelp_nw73/helpdata/en/57/0b2c4142aef623e10000000a155106/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/24/4cad3baabd4737bab64d0201bc0c6c/content.htm

Re: Convert Text file to XML

former_member160167 — Tue, 11 Jun 2013 07:54:10 GMT

Hi Pankaj,

Udo is right. The simple file content conversion function in file sender channel will not do the job here.

You may need external program or write a module processor to get it done.

Regards,

Daniel

Re: Convert Text file to XML

Former Member — Wed, 12 Jun 2013 06:22:40 GMT

Hi Daniel,

Yes, even I tried with FCC at first but could not find the right parameters, even XSLT does not help.

I will try with a module to convert the data into XML; will get back if I stuck somewhere.

Thank you!