Skip to Content

XML to CSV conversion in HCI.

Dear Experts,

I am facing issue while converting XML to CSV.

Below is the Source structure.

<Header> <Field1>ABC</Field1> <Field2>123</Field2> <Field3>XXX</Field3> <Field4>567890</Field4> <Items> <F1>ABC</F1> <F2>123</F2> <F3>XXX</F3> <F4>567890</F4> </Items> <Items> <F1>ABC</F1> <F2>12g3</F2> <F3>XXgX</F3> <F4>567fd890</F4> </Items> </Header> <Header> <Field1>654</Field1> <Field2>16d5463</Field2> <Field3>XX6d4X</Field3> <Field4>d</Field4> <Items> <F1>ABC</F1> <F2>12d3</F2> <F3>XXdX</F3> <F4>567890</F4> </Items> <Items> <F1>ABC</F1> <F2>12d3</F2> <F3>XXX</F3> <F4>567890</F4> </Items> </Header>

It is converting as

Field1,Field2,Field3,Field4

ABC,123,XXX,567890

654,16d5463,XX6d4X,d

F1,F2,F3,F4

ABC,123,XXX,567890

ABC,12g3,XXgX,567fd890

ABC,12d3,XXdX,567890

ABC,12d3,XXX,567890

I need the output as

Field1,Field2,Field3,Field4

F1,F2,F3,F4

ABC,123,XXX,567890

ABC,123,XXX,567890

ABC,12g3,XXgX,567fd890

654,16d5463,XX6d4X,d

ABC,12d3,XXdX,567890

ABC,12d3,XXX,567890

Please help me.

Thanks & Regards,

Neelima

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Nov 05, 2018 at 10:05 AM

    What is your desired format?

    Add comment
    10|10000 characters needed characters exceeded