How to fetch data from fixed length file in SOA/XSLT

User_FQCBN
User_FQCBN Posts: 1 Green Ribbon
edited June 27 in General

Hi All,

I have a requirement in SOA to Read/Write fixed length file from source/destination by applying condition on each line, below are the sample of .dat fixed file.

165 5454 abc

333test file

45466 567testfile

567343 567

77777

3564

4876

5234

77777

I need to validate each line. Ex:- if first line started with 1 then check for next line otherwise error and so on. I created xsd for the same and used file adapter using native format builder /fixed length for reading/writing so all the fixed length data came under the single C1 column but the issue is I am unable to validate/fetch the data. Please help if anyone have idea of fetching data from C1 column in fixed length file.

Martien van den Akker

Regards,

Nilesh Jha