.csv to xml conversion

[former_member751869]

Hi , I need to convert .csv file into xml .

File structure of .csv file is like this.

Header - field1, field 2, field3, field4, field5

Line1 - HeaderLineitem-field1,HeaderLineitem-field2, HeaderLineitem-field3,HeaderLienitemfield4, HeaderLineitem-field5,HeaderLienitemfield6,HeaderLineitem-field7

Line 2 - Lineitem-field1,Lienitemfield2, Lineitem-field3,Lienitemfield4, Lineitem-field5,Lienitemfield6 upto 11

Trailer - Trailer-fiield1,Trailer-fiield2,Trailer-fiield3,Trailer-fiield4.

FileHeader - 1..* / DocHeader - 0..* / DocLineItem - 0..*

File looks like -

H,test,20210513,184536,test Apr 2021,3,,,,,

1,1,I22S,20210430,0L,test,NI22S003550.4,,,, 2,1269240001,,100.23,Test,NI22S005501.1,120,I22828,I22829,DEUS05,100053 2,6419197001,100.23,,Test,NI22S005501.1,500,I22828,I22829,DEUS05,100053 1,2,I22S,20210430,0L,Test,NI22S003550.4,,,, 2,1269240001,,200000,Test,NI22S005501.1,120,I22828,I22829,DEUS05,100053 2,6419197001,200000,,Test,NI22S005501.1,500,I22828,I22829,DEUS05,100053

F,20210513,184536,3,,,,,,,

Can any one please help how to do achieve this. step wise. Thank you.