At 06:14 PM 3/20/2005 -0500, Bob Main wrote: >Anybody know how to convert a .adi into a comma delimited file? I downloaded my LoTW report and I need to convert it so I can import it into Excel.
If you have Excel you must have Word. This might do what you want. 1. Open the .adi in Word. 2. Go to Edit -> Replace 3. In Find What, type "^p" (no quotes) 4. In Replace With, type, "," (no quotes) 5. Press "Replace All" and "OK" 6. In Find What, type "<" (no quotes) 7. Press "Replace All" and "OK" 8. In Find What, type ">" (no quotes) 9. Press "Replace All" and "OK" 10. In Find What, type "eor" (no quotes) 11. In Replace With, type "^p" (no quotes) 12. Press "Replace All" and "OK" 13. At the begining of the file, select and delete everything before and including "EOH," 14. Save the file a xxx.txt. Open the file in Excel and select "," as the delimiter. >From here it's up to you to tweak the data. From [EMAIL PROTECTED] Mon Mar 21 19:29:35 2005 From: [EMAIL PROTECTED] (George Harlem W1EBI) Date: Mon Mar 21 19:33:52 2005 Subject: [Dxbase] K2TA report Message-ID: <[EMAIL PROTECTED]> Joe, is there any way to revise the K2TA report to show the band columns in ascending sequence, i.e. from 160m to 10m, as in the DXCC Award Credits Listing from ARRL? I'm trying to resolve a few differences between my log and DXCC and it's really time consuming comparing the two almost-similar reports--the K2TA columns now read "160-80-40-20-10-30-17-12". I guess I know why, but how hard would it be to change? George W1EBI
