File Content Conversion in PI 7.1

[Former Member]

Hi

I am working on File (Input file is text file) to Proxy scenario where sender sends the file,

Please find the sample data, 1st record is header and last one is trailer, and 2nd and 3rd record formats are different, File will have 2nd and 3rd format sequentially (ex 2format, 3rdformat, 2nd format, 3rd format......)

0200

1BFKKOPKC_C MC -20090803-01MC 5444002244564364 1,100.00-USD

2BFKKOPKD_C MC -20090803-0190000000006520090112 2009073000000000BOSTON RED SOX

1BFKKOPKC_C VISA-20090803-01VISA4011080000404419

2BFKKOPKC_C VISA-20090803-01VISA4011080000404416

1BFKKOPKC_C VISA-20090803-0190000000006620090112

2BFKKOPKC_C VISA-20090803-0190000000006720090112

1BFKKOPKC_C VISA-20090803-01VISA4011080000404450

2BFKKOPKC_C VISA-20090803-01VISA4011080000404450

3BFKKOPKS_C 5,500.00-USD 5

4BFKKOPKS_C 5,500.00-USD

Can anyone give an idea how to declare the values in File content conversion and process the file,

what are the parameters needs to be declared in the File content Conversion

Thanks a lot

PR

[Former Member]

PR ,

You would be needing these ones.. :

NameA.fieldNames

NameA.fieldSeparator.

NameA.endSeparator

NameA.fieldFixedLengths (this one not sure though....depends upon ur req,..)

Regards,

[venkatanarayana_vagu]

Hi PR,

Try this blog: /people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30