Skip to Content
0

Flat file conversion

Feb 08, 2017 at 07:42 AM

55

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Apu Das Feb 08, 2017 at 09:03 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
charan reddy Feb 08, 2017 at 01:03 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Raghuraman S Feb 08, 2017 at 01:22 PM
0

Hello charan,

Remove the below parameter and try

Record.endSeparator = 'nl'

Share
10 |10000 characters needed characters left characters exceeded
charan reddy Feb 08, 2017 at 01:30 PM
0

Let me check now.. Thanks..

Share
10 |10000 characters needed characters left characters exceeded
charan reddy Feb 20, 2017 at 04:31 AM
0

It's worked fine ... Thanks Raghu

Share
10 |10000 characters needed characters left characters exceeded