File Content Conversion in PI 7.1 (file to Proxy)

[Former Member]

Hi

I am working on a file (text) to Proxy scenario in PI 7.1 version, where I receive the file as shown below

1. Record is header

2. 2nd and 3rd records are Details with the different formats

3. Last Record is trailer

File will have the 2nd and 3rd records sequentially, ex file will have 2nd format, 3rd record format, 2nd record format, 3rd record format, 2nd record format, 3rd record format like that

0200

1BFKKOPKC_C MC -20090803-01MC 5444002244564364 2009073000000000BOSTON RED SOX

2BFKKOPKD_C MC -20090803-0190000000006520090112

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 5

Can anyone let me know what are the parameters needs to be declared in the file content conversion, and how to process the file if the file contains different formats sequentially

Thanks a lot for the input

PR

[Former Member · Accepted solution]

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,

Edited by: Santosh Rawat on Aug 10, 2009 11:17 AM

[Former Member]

Thanks

PR

[venkatanarayana_vagu]

Hi PR,

Please before opening a thread, try with the search terms in forum. I already given some clue for this query:

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