Re: Got an XLS spreadsheet. Need a DB2/400 file. What's the easiest way to get from one to the other?

Late Friday afternoon, eager to "make like a tree and get out of here," I wasn't exactly in the mood for an empirical solution to figuring out how to edit the .fdfx file. This morning, I was, and it turned out that the most obvious solution was the correct one.

From:

[Data Transfer File Description]
FieldCount=10
FileType=12
ClientFileEncoding=UTF-8
DataTransferVersion=1.0
[Options]
DateFormat=1
DateSep=1
DcmlSep=1
TimeFormat=1
TimeSep=1
[F0001]
Length=9
Name=CDATE
Type=2
[F0002]
Length=7
Name=CTIME
Type=2
[F0003]
Length=10
Name=CUSER
Type=1
[F0004]
Length=9
Name=LDATE
Type=2
[F0005]
Length=7
Name=LTIME
Type=2
[F0006]
Length=10
Name=LUSER
Type=1
[F0007]
Length=10
Name=LJOB
Type=1
[F0008]
Length=10
Name=LPGM
Type=1
[F0009]
Length=14
Name=EMID
Type=2
[F0010]
Length=100
Name=EMADDR
Type=1

to

[Data Transfer File Description]
FieldCount=2
FileType=12
ClientFileEncoding=UTF-8
DataTransferVersion=1.0
[Options]
DateFormat=1
DateSep=1
DcmlSep=1
TimeFormat=1
TimeSep=1
[F0001]
Length=14
Name=EMID
Type=2
[F0002]
Length=100
Name=EMADDR
Type=1

Stuffing some constant value into the other 8 fields will be easy enough.