Create fixed width file with different line definitions

Question

The batch we're developing requires a fixed width input file with different line definitions for each entity. Eg. the first line defines a family, the second and third line define family members of that family. The family record has different column definitions than the family member records.

I would like to create test cases in something human-readable (even if it has to be Excel) and then convert it to the input file format.

Any suggestions on how this can be done without too much hassle?

score 1 · Accepted Answer · answered Sep 04 '12 at 09:22

1

XML and XSLT is probably going to be the best options.
You should try that and post question updates if you encounter problems.

answered Sep 04 '12 at 09:22

Germann Arlington

3,315
2
17
19

Creating the xslt templates was a bit of a pain (keeping the multiple whitespaces was a challenge), but it paid off in the end. Thanks again. – Hilde Dierckx Sep 05 '12 at 07:46

Create fixed width file with different line definitions

1 Answers1