Skip to Content
avatar image
Former Member

FTP Sender Adapter - Dynamic fields in a comma separator csv

Hi Gurus,

I have to design a simple FILE to proxy interface.

The file has a header with field names, and everything is separated by comma.

This is the way the file is coming:

A,B,C

1, name1, id

1, name2, id

1, name3, id

So header is A,B,C and rest are the values that need to be maped (rows).

This is easy to do with FCC, but there are some cases like this:

A,B,C

1, name1, id

2, name2, id, name3, id

1, name4, id

3, name5, id, name6, id, name7, id

1, name8, id

As you can see, the first number tells the quantity of repetitive columns B and C and I need this information to be in my structure.

Is anyone able to let me know if there is a way to catch all the data of the .csv with File Content Convertion?

I hope I was clear, otherwise just let me know.

Thanks!!!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 25, 2017 at 06:47 AM

    can you translate this flat file into expected xml?

    A,B,C

    1, name1, id

    2, name2, id, name3, id

    1, name4, id

    3, name5, id, name6, id, name7, id

    1, name8, id

    what are the max no of occurrence of names and id in one row? 3 times is the max?

    3, name5, id, name6, id, name7, id

    Regards,

    Muni

    Add comment
    10|10000 characters needed characters exceeded