[Dx4win] Deleting Error messages in QSO notes?

[Nelson Moyer]

John,

You may not want to use a cvs file from Excel as an import file. I converted
a Macintosh database file to cvs through Excel and Excel stripped the
leading zeros from UTC times. I never figured out how to set the cell number
format to accept leading zeros in Excel. I was using the HHMM format, and
DX4WIN 6.02 times with the leading zeros stripped from the import file
appeared as 00:00 or ??:??. Perhaps Excel would not strip the zeros from the
HH:MM format; I didn't try it. The only way I could produce a file that
would import properly was to export the database file as comma delineated
text with return (enter on the PC) as the end of line character, open and
convert the file in Word, and save as a text file in ASCII format. The
resulting file imported into 6.02 with leading zeros intact. 

Nelson, KU0A

-----Original Message-----
From: dx4win-bounces at mailman.qth.net [mailto:dx4win-bounces at mailman.qth.net]
On Behalf Of John DeRuiter
Sent: Wednesday, May 12, 2004 9:21 AM
To: Steve
Cc: DX4WIN reflector
Subject: RE: [Dx4win] Deleting Error messages in QSO notes?

Steve,

Ok. I give up. How do you export to Excel and then import again.  I know
that you can write to a .csv file by right clicking on the log window and
that can be imported by Excel, but I don't see a way to import from Excel.

John DeRuiter, WM7A
http://members.cox.net/wm7a/


-----Original Message-----
From: Steve [mailto:steve at stevebb.com]
Sent: Wednesday, May 12, 2004 3:30 AM
To: John DeRuiter
Cc: DX4WIN reflector
Subject: Re: [Dx4win] Deleting Error messages in QSO notes?


Hi John,

There is a way around it, another user of this forum recommended for me as I
have over 200,000 records and did not fancy the prospect of removing each of
the errors individually.

You can output the file into excel and this way it is easier to clear the
field - easy if there is no other information you wish to keep in that field
(as Guy has previously mentioned).

It would of course be nice to have a few lines of extra code just to compare
the first word in this field ie if it sees the word "Error" as the first
word prompt to delete the field. Maybe for the next version if there is
enough call for it  ;-)

Hope this helps,

Steve  G4KIV / ZC4BS


Homepage:  http://www.stevebb.com
Photo portfolio: http://www.usefilm.com/photographer/33060.html
Email:  steve at stevebb.com



_______________________________________________
Dx4win mailing list
Dx4win at mailman.qth.net
http://mailman.qth.net/mailman/listinfo/dx4win