MQSeries.net :: View topic - Validating the fixed width file read using File Extender

valentine · Posted: Tue Dec 19, 2006 2:13 am Post subject:

Hi,

I am using the File Extender to read a fixed width file which has one header and multiple childs as below:-

abb
cccdddd
cccdddd
cccdddd

There are two issues that I am facing:-
1) The file extender does not throw a validation error when the data exceeds the expected length.
2) Since the file is a fixed width file I have created TDS message set and have entered the length of each string. The issue that I am facing is that the carriage return and newline character are also interpreted as part of the data. So the data that is read is as follows:-

Header:-
Field1 - a
Field2 - bb

Child1:-
Field1 - \r\nc
Field2 - ccdd

Child2:-
Field1 - dd\r
Field2 - \nccc

Child3:-
Field1 - ddd
Field2 - d\r\nc

Please suggest what setting do I need to do for MB to ignore the new line characters and throw an error when the data exceeds the limit.

Thanks,
Valentine