Traffic Tools question

[Joe_Alferio]

I am trying to edit and add to the aircraft and flight plan text files by importing them to a database or spreadsheet that allows me to manipulate the data easier than a straight text generator. I have successfully imported the files and saved them as datbase and spreadsheet files.

My problem is that when I export the spreadsheet or database files back to text files, the program is putting quotation marks in front of and behind all of the data.

For example, as decompiled, a line in the aircraft.txt file will look like this:

AC#1,200,"Beech Baron 58"

Notice that their are quotation marks around the aircraft title but not around the aircraft number or the speed.

Now, when I convert the text file to a spreadsheet and then back to a .csv file, I get this:

"AC#1",200,"Beech Baron 58"

Notice the extra quotation marks around the aircraft number. The tdcompiler will not recognize the extra quotation marks.

If I use the spreadsheet to save as a .txt file, this is what I get:

AC#1 200 Beech Baron 58

As you can see, now it's been saved as text and tabs. The tdcompiler will not recognize this format without the commas.

These are all made with Microsoft Works, version 6.0.

When I import the flightplan file into the database part of Works, and then try to convert back to .txt, I get quotation marks all over the place.

"AC#24","N8552","87%","12Hr","IFR","1:53:50","7:01:00",100,"F",7770,"CYKZ","7:53:44","13:00:55",90,"F",7771,"CYHZ"

If anyone has succesfully edited and then resaved these files using any spreadsheet or database program, I would surely be interested in hearing from them. It would make life a lot easier if we could edit these files with something stronger than wordpad or notepad.

Joe A.

[Fer]

I just bought a book of quotes and you got a whole bunch for free!! :-lol
Now seriously, I hereby declare: You have a serious quotation problem. please don't quote. :-lol