Mapping from hierarchical data text file to XML

Content

Hello, community.

 

I've just got this really hard integration task. I have a text with the following content:

 

1,0042

2,1,Pen,10

3,4,across the street

3,6,across the bridge

2,2,Eraser,6

3,6,across the street

 

The first character of each line means the line's type: 1 stands for "purchasing order header", 2 stands for "purchasing order line" (items that I must deliver) and 3 stands for "purchasing order line locations" (where to deliver).

 

Putting it in a better view for hierarchical comprehension:

 

1,0042

   └2,1,Pen,10

      └3,4,across the street (from the top to here will become first line in the temporary stage file mentioned at the end of this post)

      └3,6,across the bridge (from the top to here will become second line in the temporary stage file mentioned at the end of this post)