Problem with PIPE as a field separator

[Former Member]

Hi Gurus,

I am facing a problem in XI .The incoming file is PIPE as a field separator and a carriage return as end of each record.

The problem is that in trailer record if the last field has no value in the file then it is unable to identify it is a field.So all mapping which is there to check the empty filed is not working.

File format processed with status ok.

01|HEADER|F1

02|F1|F2|F3

03|COUNT1|F4

if the same file in the last record if the filed XX is blank then it is not able to trap in mapping.

01|HEADER|F1

02|F1|F2|F3

03|COUNT1|XX

If i am giving a extra PIPE at end of each record then it is working ok and the mapping can able to check if a field is blank.

But without putting a PIPE at the end is it possible to trap error if any last field is contains blank.

it is little URGENT.Please reply.

Thanks,

Satya

[turmoll · Accepted solution]

Hi,

Suppose you called 03|COUNT1|F4 row as "trailer" in recordset structure.

Then you can use the following parameters:

trailer.missingLastfields = ignore - to get converted to XML only fileds that have been filled in

trailer.missingLastfields = add - to have last fileds filled with empty values

trailer.missingLastfields = error - to terminate FCC since file has not complete structure

Regards,

Jakub

[Former Member · Accepted solution]

Hi All,

We have solved the problem.Actually the field in question is the last field of the trailer .Mapping is also there to check for NON blank case since XI not able find that a field itself so it is unable to trigger the valdation mapping done for that field.

Also the same field was not mapped to any other fields in the target structure.So we just mapped this field to target structure and after that XI start identfying the field and also it is validating.

Thanks for all your answers.

Satya Jethy

[Former Member]

Hi All,

We have solved the problem.Actually the field in question is the last field of the trailer .Mapping is also there to check for NON blank case since XI not able find that a field itself so it is unable to trigger the valdation mapping done for that field.

Also the same field was not mapped to any other fields in the target structure.So we just mapped this field to target structure and after that XI start identfying the field and also it is validating.

Thanks for all your answers.

Satya Jethy

[Former Member]

Hi,

You need to specify the fieldNames along with field seperator in the FCC conversion.

Fieldnames will help to identify the columns and will be able to consider the values from kast line also.

Here you define the endSepearator as carriage return.

This will work out.

Thanks

Swarup

[Former Member]

hi.

PLz try with field.endSeparator.

[Former Member]

Hi,

We have taken the field.endSeparator = 'nl' .Still XI is not able to recognize a field missing.

Thanks,

Satya Jethy