Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to Fetch data from fixed length file .DAT

User_FQCBNJun 26 2022 — edited Jun 27 2022

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.

Regards,
Nilesh Jha

Comments
Post Details
Added on Jun 26 2022
0 comments
301 views