Sign-in / Sign-up
Your question

Rearranging/sorting Scenery.cfg in Excel works!!

Tags:
  • Macros
  • Excel
  • Video Games
Last response: in PC Gaming
March 31, 2005 2:55:45 AM

Archived from groups: alt.games.microsoft.flight-sim (More info?)

Have used text editor macros to format the Scenery.cfg file into a
form that Excel SS can open (TXT file).. and then using the SS `sort
function'.. rearranged the entire block. Also straightened out columns
(the order of each line entry) so that they're all uniform.. i.e.
Area.. followed by Layer.. followed by Title.. etc.

The result is.. each [Area.xxx] now is equal to the Layer=x line.

Plus they're all in perfect order and not 209 entries as previously
stated.. only 179 because many had been deleted. Finally.. macros
to parse and add CRLF's back into original form.

What good is this? well proves it can be done.. although not too
easily.. but still less than two hours effort. :)  Now the Scenery
CFG is in a SS and can be sorted by ANY column. Will post more
if interested. Tested out OK!!


-Gregory

More about : rearranging sorting scenery cfg excel works

March 31, 2005 2:01:38 PM

Archived from groups: alt.games.microsoft.flight-sim (More info?)

On Wed, 30 Mar 2005 22:55:45 -0500, Gregory
<flightsim.maps@bkwds.comcast.net> brought the following:
>
>Have used text editor macros to format the Scenery.cfg file into a
>form that Excel SS can open (TXT file).. and then using the SS `sort
>function'.. rearranged the entire block. Also straightened out columns
>(the order of each line entry) so that they're all uniform.. i.e.
>Area.. followed by Layer.. followed by Title.. etc.
>

Have found a utility that will sort and renumber Scenery.CFG

http://www.fs-traveler.com/resources-g.shtml


it's the third link from top.. have tested and works ok.. no GUI but
status boxes pop up with info. would seem to ALSO work with FS2004.
make backup of CFG first.. make TWO BACKUPS just in case.. like:

Scenery(version that works before messing with it).CFG


-Gregory


p.s. sorts Area and Layers.. still not as complete as SS method