Results 1 to 8 of 8

Thread: CSV (Comma Delimited) file

  1. #1
    architech Guest

    CSV (Comma Delimited) file

    This is for "Bprime" who aksed about "automatically" drawing with points.

    This question comes up many times...

    I have survey points and want to use them...
    Anyone know how to solve this...
    For the most part this is basically a plain TXT file in a *.CSV format.

    [MS Excel exports to this format]

    Anyone have an example to share... a solution or sample?

  2. #2
    Join Date
    Mar 2004
    Location
    39.739ºN, 104.984ºW
    Posts
    1,009
    I've always had a civil design program so I'm never had to "think" this one through.

    However, you most certainly can manipulate a word document to be pasted into the command line prompt.
    Do some data filtering in excel then export to a .cvs then copy past that info into a line or pline command


    (don't forget to take out the point number and description before your copy past)

  3. #3
    architech Guest
    bprime

    see the attached file

    and just in case you can't see it...


    line 0,0 12,12
    line 12,12 32,32
    ^c^c
    Attached Files Attached Files

  4. #4
    architech Guest
    you need a blank line in between command lines...
    See attached file....

    to load
    type script
    enter key
    point to file
    and run

  5. #5
    Join Date
    Jun 2004
    Location
    Anchorage, Alaska
    Posts
    1,179
    Architech,

    For posterity you might want to correct the title, "CSV" for comma separated variable.

    A few comments for a first time script user;
    "returns" can be accomplished with a space or with a "new line", spaces are harder to debug.

    For multiple "line" command calls, you could use a return to repeat the command, such as;

    ----------------
    line
    0,0
    12,12

    12,12
    12,32
    --------------
    And if lines are from point to point (all connected) you wouldn't need to issue multiple calls to line, just;
    ----------------
    line
    0,0
    12,12
    12,32
    etc...
    --------
    As VCD mentioned, once you had the text file formatted, you could start the "line" command in AutoCAD, then copy & paste the coordinate text to the command line.

  6. #6
    architech Guest
    I knew you would chime in eventually....

    This has been a questioned asked ... more than once...
    And I recall seeing the 1st solution coming from you... AWHILE back...


    Quote Originally Posted by CarLB View Post
    Architech,

    For posterity you might want to correct the title, "CSV" for comma separated variable.
    In any case...
    The title reflects the name designation in MS Excel 2007....

    But your comment is noted...
    And here for the record... thanks



    And thanks for the detailed response!
    Once again - helpful as always...

    Have a happy New Year Carl!

  7. #7
    Join Date
    Jun 2004
    Location
    Anchorage, Alaska
    Posts
    1,179
    Yeah I'm late to many of these discussions, being in the Alaska time zone

    Well the CVS is new to me, maybe I'm behind the time zone again, my Excel 2003 and all previous used CSV.

    Happy New Year to you, and all "AC Everything'ers" also

  8. #8
    architech Guest
    I meant the part about "Comma Delimited"... is how it is referred to in Excel.

    My typo mistake....
    I changed it from CVS to CSV....

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •