ACSII file Convert to XML

[Former Member]

Hi All,

My Inpit file is like below:

;<start of entry>

0

12/01/09

abc-123-3

sales

;<end of entry>

;<start of line>

client

aaaa 2345-1

ddd

ffff

0

0

0

gb

1

0.00

0.00

like that we have 103 rows

;<end of line>

;<start of line>

103 rows

;<end of line>

Can any one plz help me how can i get the xml of this and is it possible to read the empty lines? i have 103 files(rows) in the line data.

Thanks in advance

Karthik.

[Former Member]

Hey

Won't you be able to handle this simply by File content conversion in sender file adapter?

I m unable to understand whats the exact issue you are facing here.

Thanx

Aamir

[Former Member]

Hi,

I am working on FILE TO IDOC scenario. Can u plz help me how can i get the xml of this and is it possible to read the empty lines? i have 103 fieldes(rows) in the line data.

In this Header and line item also contain multiple records and each and every field value is coming in the new line. and some fileds are have no values at the time how can i read the empty lines. I tried using 'nl' as a field separator but it is giving error. Plz Help me on this.

My Inpit file is like below:

;<start of entry>

0

12/01/09

abc-123-3

sales

2

;<end of entry>

;<start of line>

client

aaaa 2345-1

ddd

ffff

<Space>

.

.

0

0

0

gb

1

<Space>

.

0.00

0.00

like that we have 103 rows

;<end of line>

;<start of line>

103 rows

;<end of line>

Thanks

Karthik

[former_member181962]

Hi Karthikeya,

You should define your data type with a root node as say, root.

Under that node you should have one node for header with 4 fields(For start of entry-end of entry)

Another node for Items with 103 fields with occurance as 0:unbounded for the node.

Then you can use the sender file adapter settings as described here

http://help.sap.com/saphelp_nwpi71/helpdata/en/44/6713ec3f914ddee10000000a1553f7/content.htm

Regards,

Ravi