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

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Nicely done, James! These things are like - or actually are - INI files, 
the original does seem to have fairly obvious items to remove and 
change, like the count.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.DWtt1v7w.CnL0QgHr@centurylink.net> CAAC 
(COMMON Americas Advisory Council) IBM Influencer 2023


On 7/13/2026 11:17 AM, James H. H. Lampert via MIDRANGE-L wrote:
> 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.