CAD Forum - Database of tips, tricks and utilities for AutoCAD, Inventor and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 6283
Arkance Systems CZ
FB TW YT LN Blog
RSS channel - CAD tips RSS tips
RSS discussions

Discussion Discussion forum

 

HelpCAD discussion

 
CAD Forum - Homepage CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.

Please abide by the rules of this forum.

How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedExport points to csv in a specific order?
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Anchor_maan View Drop Down
Newbie
Newbie


Joined: 06.Sep.2010
Location: Canada
Using: Autocadd 2007
Status: Offline
Points: 1 		Direct Link To This Post Topic: Export points to csv in a specific order?
    Posted: 06.Sep.2010 at 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
AC
Back to Top
ffinybryn View Drop Down
Newbie
Newbie


Joined: 01.Oct.2010
Location: United Kingdom
Using: AutoCAD 2010
Status: Offline
Points: 1 		Direct Link To This Post Posted: 01.Oct.2010 at 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 = 0
Command: '_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:
 
 
The filename can be CSV or TXT.  Output is comma delimited and can be viewed in a text editor or best in Excel.
 
 
 
 


Edited by ffinybryn - 01.Oct.2010 at 19:24
Back to Top

Related CAD tips:


 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0,336 seconds.
CF
CAD Forum - tips, tricks, utilities, discussion for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, 3ds Max, Fusion 360 and other Autodesk software (support by Arkance Systems)
Arkance Systems CZ (CAD Studio) - Autodesk Platinum Partner & Training Center & Services Partner
CONTACT:
webmaster.cz@arkance-systems.com
tel. +420 910 970 111
  Copyright ©2024 | Advertise with us | Online privacy
FB TW YT LN Blog
TOPlist