08.04.2008, 08:32
Well this method seems to work, but needs more testing.
I've done this working with TextPad and Excel 2007
1. Import outBuildings.txt into Excel as *.txt file type.
Choose Delimited and Space for the import options to get the data sorted in columns.
2. The coordinate data is in columns E F and G. Add three new columns H I J for the new coordinates and enter formulas to make the correction. Note, I am assuming that you already know how to use a spreadsheet.
3. Copy and paste H I J columns and use option to paste value only. This gets rid of the formula.
4. Delete obsolete coordinate columns. You now have a new outBuildings.txt to save.
5. Save As/Other Format -- Choose Unicode text as type.
6. You can now view the new file in TextPad or similar text editor and continue to process using Actors Tools.
I've done this working with TextPad and Excel 2007
1. Import outBuildings.txt into Excel as *.txt file type.
Choose Delimited and Space for the import options to get the data sorted in columns.
2. The coordinate data is in columns E F and G. Add three new columns H I J for the new coordinates and enter formulas to make the correction. Note, I am assuming that you already know how to use a spreadsheet.
3. Copy and paste H I J columns and use option to paste value only. This gets rid of the formula.
4. Delete obsolete coordinate columns. You now have a new outBuildings.txt to save.
5. Save As/Other Format -- Choose Unicode text as type.
6. You can now view the new file in TextPad or similar text editor and continue to process using Actors Tools.