I have a requirement to generate an outbound flat file with following requirements:
- fixed record size, say 20 for each record.
- for each record, from field1 to field3 only can be repeated 1 time with total fixed length 10.
- from field4 to field5, total length is 2 but can be repeated up to 5 times. Blanks will be fullfilled for un-repeated spaces.
For example, I need two records in file:
How do I create a schema to cover this structure?
I am using separate schemas to handle f1f2f3 and repeating f4f5 then concat two string together. (sounds kind stupid…)