Need an urgent help on the following flatfile issue.
As per my requirement, I am trying to process a fixed length flat file along with field separator as ‘|’ and record separator as ‘new line’. I have created the schema and it is parsing all the values as a single string(like 111222333444).
I try to explain with the example:
Field1: Value=111, length=3;
Field2: Value=222, length=3;
Field3: Value=33, length=3;
Field4: Value=444, length=3;
Output record length required=12
So my output file looks like:
Rec1(separated fields by ‘|’ delimeter)
Please let me know is there a way to define this in schema?