Show full version of the posting: Export points to csv in a specific order?

Anchor_maan
06.09.2010, 17:39
Does any one know how to export points (x,y,z) coordinates to a csv. In the order that they were selected???? Sos

ffinybryn
01.10.2010, 09:32
Hi,
 
First post on this excellent site..!
 
I do not export points on a regular basis, but use the following method when required:
 
1.  Select the points in order, using the "Locate Point" command.
2.  Expand and Select all of the text output from the Text window
 
eg  
Command: '_id Specify point:  X = 1096     Y = 482     Z = 0Command: '_id Specify point:  X = 1185     Y = 1019     Z = 0
etc
 
3.  Select & Copy the text and paste it into "Notepad" or other text editor.
4.  Save As "CSV.txt"
5.  Open Excel
6.  Open "All Files(*.*)" CSV.txt
7.  When prompted, Select option "Delimited", tick "Space" option
This breaks the text into separate columns - otherwise whole line will go into one cell
8.  Delete the columns that are not required.
9.  Edit/Save the Excel file as required.
 
Hope this helps.
 
Mark
 
Edit:  I have just written a short VBA macro that does this directly:
 
www.engineeringsurveyor.com/software/macros/exportxyz.zip 
 
The filename can be CSV or TXT.  Output is comma delimited and can be viewed in a text editor or best in Excel.
 
 
 
 ffinybryn2010-10-01 19:24:51