File Content Conversion

[Former Member]

Hi,

I have the below file structure;

LBB200701051018350004136939A1LY Modify

B4BB74 A1LY01LIGHT CHARCOAL-NBA LGHCHANBA ULGCHNB

B4BB74 A1LY02LIGHT CHARCOAL-NBA LGHCHANBA ULGCHNB

LBB200701051021240004136940A1X4 Modify

B4BB74 A1X401ORANGE-NBA ORANGENBA UORANBA

B4BB74 A1X402ORANGE-NBA RANGENBA UORANBA

This is a fixed length file. The file has repeating structure like the first 3 rows.

How to configure it in file adapter.

Your help will be appreciated.

Thanks

[Former Member]

Thanks Guru.

[Former Member]

Datatype_dt

- Record 1..unbounded

-Record1 1..unbounded

-field1

.

-fieldn

-Record2 1..unbounded

-field1

.

-fieldn

-Record3 1..unbounded

-field1

.

-fieldn

In the file content conversion

RecordSet Structure : Record,*, Record1,1,Record2,1,Record3,1

For converstion parameters use the following blog

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

Message was edited by:

Guru