• Blog posts


    By David Lewis

    In Part 2 of this process ‘Extracting 3D Data from 2D Text’ we looked at how to extract the X, Y and Z position of text based on the text insertion point and the contents of the text to establish a value for the level.

    In Part 3 we will look at 2 different methods for reinserting the extracted information into AutoCAD depending on the desired output. Method 1 will be based on a combination of excel and points where as method 2 is more involved and will require the use of an attribute block and AutoLisp Routine.

    Method 1: Display 3D Point Data only

    This method involves manipulating the extracted .csv file in either excel or notepad so the information is displayed in 1 cell and separated by commas. In this example I will be using excel.

    1. Open the extracted data file with Microsoft Excel. Select an empty cell, preferably cell E2.

    2. Select the Formulas Tab on the Ribbon, and on the Text dropdown menu select CONCAT (short for CONCATENATE). See Fig 1. This tool will be used to combine the values in column A, B and C with a comma separation.AutoCAD_2019_-_Converting_2D_Data_to_3D_-_Part_3A_-_1.PNG

    3. This will open the Function Arguments dialogue box. See Fig 2. Here we will combine the information in columns A, B and C into 1 cell with a comma separation.


    4. As the Position X, Position Y and Value text along row 1 are not relevant for our reinsertion into AutoCAD, select cell A2 to populate the Text1 box on the functions Dialogue box. Then in Text2 type a comma. Additional boxes will appear each time you select a cell to populate one of the Text Rows. See Fig 3. Continue to select cell B2 for Text3, place a comma in Text4 and select cell C2 for Text 5. See Fig 4.

    When complete press ok on the Function Arguments dialogue box.


    5. Having completed the Function Argument, you will be returned to the Excel spreadsheet.

    Cell E2 should be populated like Fig 5 below, with the exception of the values being displayed as they will relate to your extracted data.


    6. Now select the green square in the bottom right hand corner of cell E2 and drag down to the end of your data set to populate the remainder of the cells in the same format. See Fig 6.


    7. Select all the data in Column E and copy (Ctrl +C).

    8. Open AutoCAD and select the Multiple Point tool from the Home tab on the ribbon by expanding the Draw Panel. See Fig 7.


    9. Navigate to the command line in AutoCAD and using the right click on the mouse select the paste option. See Fig 8.


    10. The points have now been inserted into the AutoCAD drawing. If they are not visible double-click the scroll wheel on the mouse to zoom extents.

    11. The ways the points are being displayed can be changed by expanding the Utilities panel and selecting Point Style… See Fig 9.