• Which the release of FS2020 we see an explosition of activity on the forun and of course we are very happy to see this. But having all questions about FS2020 in one forum becomes a bit messy. So therefore we would like to ask you all to use the following guidelines when posting your questions:

    • Tag FS2020 specific questions with the MSFS2020 tag.
    • Questions about making 3D assets can be posted in the 3D asset design forum. Either post them in the subforum of the modelling tool you use or in the general forum if they are general.
    • Questions about aircraft design can be posted in the Aircraft design forum
    • Questions about airport design can be posted in the FS2020 airport design forum. Once airport development tools have been updated for FS2020 you can post tool speciifc questions in the subforums of those tools as well of course.
    • Questions about terrain design can be posted in the FS2020 terrain design forum.
    • Questions about SimConnect can be posted in the SimConnect forum.

    Any other question that is not specific to an aspect of development or tool can be posted in the General chat forum.

    By following these guidelines we make sure that the forums remain easy to read for everybody and also that the right people can find your post to answer it.

Excel

wbunnell

wbunnell

Messages
390
Country
us-maine
So that I don't get feedback about other programs to make flight plans. I have used Excel for the better part of 10 or 12 years, and am quite satisfied with it.
Is there anyone else using it, if so, when you put your flight plans in Notepad from CSV(comma delimited), how do you get rid of all them commas(,,,,,,,,,) after each flight plan? Without highlighting the line then deleting.
AC#469,60-0031,23%,WEEK,IFR,1/22:41:47,2/06:25:40,250,F,98,EGVA,2/23:45:25,3/03:23:12,260,F,98,LTAG,5/00:53:37,5/06:36:55,310,F,98,LPLA,6/19:53:54,0/02:11:40,330,F,98,KBAD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
 
I was searching on another problem when I stumbled upon this question. If you haven't yet found a solution, I have one. This is a note I wrote for myself when I discovered this method:

Converting flightplans to Excel worksheet and converting back to text file (I tried this with Excel 2007).
Flightplans in a worksheet format gives a much clearer picture. You can make changes by converting to a spreadsheet, edit it, then convert back to text. Or make a new flight plan with Excel, then convert to text.

Going From txt to Excel To go from text to Excel, decompile traffic (bgl) file. Open Excel. Then in Excel, Open flightplan.txt file. Text Import Wizard opens. Step 1 – choose Delimited, then NEXT. Step 2 - check Comma, then NEXT. Step 3 – do nothing, FINISH. You should have a flightplan in spreadsheet form.

Going From Excel to txt. Going from spread sheet to text is a 2 step process. First, starting with the spreadsheet, do Save As/Other Formats. Enter the File name, and under “Save as type”, select “CSV (Comma delimited), then SAVE. Click Yes on the warning. Next, open the .csv file in Notepad. Note the trailing commas at the end of some of the lines. Because the converter sees all spreadsheet rows as equal in length (the length of the longest line), it sees the trailing empty cells of the shorter rows as blank cells, and inserts a comma for each. In Notepad erase all of these trailing commas. Easiest way to do this – make sure cursor is in the upper left corner. Do Edit/Replace, and enter two commas in “Find what” and leave “Replace with” blank. Click “Replace All”. All of the extra trailing commas should be gone. Then save the file as a .txt file.

Note: Replacing commas in pairs work because there should always be an even number of trailing commas. This is because each leg in a flight plan has 6 entries. So the number of extra trailing commas should be in multiples of 6. So the double commas, or series of double commas, appear only at the end of the shorter lines.

I've used method this on a couple of FSX flight plans and it works. So I'm assuming it'll work on all flightplans. Good luck.
 
You must log in or register to reply here.
Back
Top