You can submit for dxcc with the help of dx4win. I hope you have this info. When you have the submission you can save it with right click like a csv file. You can open csv files with excel but use this way... rename the dxcc.csv to dxcc.txt (open it with notebook and save as like dxcc.txt or any other way) In excel open>choose txt files and choose to separate fields with comma then you will have a perfect excel file to work separated in cells, etc. Don't forget to save the file like an excel file after you work it. Feel free to ask agn if you have questions Kostas sv1dpi ----- Original Message ----- From: "Larry Alkoff" <[EMAIL PROTECTED]> To: "DX4win" <dx4win@mailman.qth.net>; "Jim Reisert AD1C" <[EMAIL PROTECTED]> Sent: Friday, October 20, 2006 5:01 PM Subject: [Dx4win] Need tips how to clean up garbled .csv file
>I have a thread on the DX Chat reflector titled "DXCC Application" but have >found out while processing the DX4Win log for DXCC submission that there is >one area of about 120 qsos where the file is garbled. > > To start I used DX4Win to export in .csv all qsos (about 9,000) that are > confirmed, then export them into Open Office Spreadsheet. > > The qsos in the file between number 280 and 398 have gotten out of > sequence and are not in the proper columns, although the little section of > 118 qsos seem to be nicely lined up in their own order! > > I notice that exporting from DX4Win to .csv produces a file with commas > separating the fields but there are some embedded commas - especially in > the comment fields. Can this mess up my file? > > Any tips for characters that you do not want in a file being exported? > > It _could_ be some strange memory problem but this dedicated ham Windows > 98SE machine has given me no indications of problems. > > What should I be looking for? Jim do you have any analysis tools? > > Larry > > -- > Larry Alkoff N2LA - Austin TX > Using Thunderbird on Linux > _______________________________________________ > Dx4win mailing list > Dx4win@mailman.qth.net > http://mailman.qth.net/mailman/listinfo/dx4win > >
