Skip to Content

Flat file conversion

Dear Experts,

I need help to convert below flat file structure to XML

,100, ,300,400,695,3748,3564,3564

,140, ,350,400,456,2345,34,56777

How can we give in file conversion in FCC?

Cheers

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Feb 08, 2017 at 09:03 AM

    Hi Charan,

    This looks like very simple. Your FCC should be like -

    Record.fieldNames = f1,f2,f3...............

    Record.fieldSeparator = ,

    Record.endSeparator = 'nl'

    ignoreRecordsetName = true

    Thanks,

    Apu

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 01:03 PM

    I created same like your advise but it;s taking to only one filed.

    Like below:-

    <F1>,100, ,300,400,695,3748,3564,3564<f1/>

    Cheers

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 01:22 PM

    Hello charan,

    Remove the below parameter and try

    Record.endSeparator = 'nl'

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 01:30 PM

    Let me check now.. Thanks..

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2017 at 04:31 AM

    It's worked fine ... Thanks Raghu

    Add comment
    10|10000 characters needed characters exceeded