[Dx4win] Custom import - time transfer problem
Martin Ellis
[email protected]
Sun, 12 May 2002 22:01:15 +1200
[email protected] wrote:
> Hello,
> I am transferring my hand written logs to DX4WIN using a space delimited
> Excel file (*.PRN) and the custom import feature. All data is transferred OK
> except the time. The colon separating HH:MM is replacing the 2nd digit from
> the left...e.g., 1757 is 01:57, 1823 is 01:23, 2219 is 02:19 and so on. I
> have the "Time" position starting 1 space to the left and RecLen is 5 (can't
> be changed).
Hello Stokley
When I edit a custom import filter, and choose the TIME field, I get
three boxes: Position, Length and Type.
If you click on Type you get a choice of:
Length 5 Type HH:MM
Length 4 Type HHMM
Length 6 Type HHMMSS
If your spreadsheet has a colon in the timme, choose HH:MM and start the
field in the correct position on the first digit- I think you have what
you want.
Regards,
Martin ZL1ANJ