file content conversion 'lastFieldsOptional'

[Former Member]

Hi All,

I am working on a File Sender content conversion--> flat file to XI.

it's fixed length field all the rows with same column.

090627 344535AFDFG+GBP65433 ASDSSD GFD dFSSGFD 6757532

090627 344535AFDFG-GBP65433 ASDSSD GFD dFSSGFD 6757532

090627 344535AFDFG-GBP65433 ASDSSD GFD dFSSGFD 6757532

090627 344535AFDFG-GBP65433 ASDSSD GFD dFSSGFD 6757532

090628 344536AFDFG+GBP45434 ASDSSD GFD dFSSGFD 6757532

090628 344536AFDFG-GBP45434 ASDSSD GFD dFSSGFD 6757532

**EOF**

I am sucessfully able to handle the file if i remove "**EOF*" from incoming file. But i get "lastfieldsOptional" error with "*EOF**"

There are parameters available to ignore Last field(last column) of a Row/Rocerdset

but how to ignore the last row of the file.

Plz suggest some parameter to ignore the last row/field of the file.

Regs,

Ansh

[Former Member]

Hi Leela,

by giving the mentioned parameters....system asks to define keyfield also..!

whereas i don't hav any field with constant value which can be defined as keyfield.

Regs,

Ansh

[Former Member]

Hi Ansh,

I have also faced the same problem. For that use the below parameters.

fieldFixedLengths -- 0,0

fixedLengthTooShortHandling -- Cut

Regards,

Leela

[Former Member]

Thanks for ur inputs,

i thought about reading "**EOF**" and ignoring it in mapping....but is there no parameter to ignore it while reading itself?

Regards,

Ansh

[Former Member]

Hey

Simplest solution would be to read the last records but ignore itt in Message mapping.don't do any message from that field,it wont be passed to receiver side.

Thanks

Aamir

[Former Member]

Hi,

Read the file with ***EOF**

In the mapping ignore this one.

use UDF with for loop inside that use length-1,

I think this will helps you.