Skip to Content
0
Feb 18, 2020 at 06:20 AM

Convert .csv to xml on CPI

293 Views

Hello,

we are having the follwoing challenge:

We are getting a .csv file which looks like this:

Filed1;Filed2;Filed3;Filed4;Filed5;Filed6;Filed7;Filed8;Filed9;Filed10;Filed11;Filed12;Filed13

Filed1;Filed2;Filed3;Filed4;Filed5;Filed6;Filed7;Filed8

Filed1;Filed2;Filed3;Filed4;Filed5;Filed6;Filed7;Filed8;Filed9;Filed10;Filed11;Filed12;

The first row will be just one time but row 2 and three can be there multiple times. We need to get this .csv to a xml structure to perform a mapping. Does any one has a idea how to solve this?

Regards

David