[Dxbase] Converting and adi file

[Wes (N7WS) and Linda]

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.