AutoCAD 2015 Data Extraction sorting problem need help!!!

[bgraverholt]

When I extract address attribute of my blocks AutoCAD 2015 it wont put the address attribute in descending order there are random addresses that are not in order. I cant figure out why this is doing this other drawings we do don't have this issue. In excel the addresses that are out of order show an error stating excel thinks its a date not a number like 1-12. I have attached the excel file and DWG for more explanation. I hope I can get this figured out I have probably another 2000 devices to sort and really need it to be in order. 

[virgilio_benedictos]

hi bgraverholt

in my experience with 2013, the sorting is base on the number (ascending and descending)..

for example

i have a series of number 1,2,3,,5,6,7,8,9,10,11

it sort it by first number of the value. it shows like this 1, 10, 11, 2, 3, 4, 5, 6, 7, 8, 9

so that i did this numbering with 01, 02, 03, 04, 05, 06, 07, 08, 09, 10 ,11.

its different in older version of autocad that its sort accordingly.

regards

ver

[bgraverholt]

I have tried going back to 2008 autocad and to extract the addresses and still get the same out come. Is there a lisp or add on program that will extract the information in the correct order?

[Steve_Bessette · Accepted solution]

The data extraction appears to be pulling the information as it is listed within the drawing.  The format of the "address" attributes is not uniform which could be contributing to the issue.  The information that is placed into the "address" attribute will extract as is. One workaround for this, other than editing the data within the drawing itself, is to filter the data within the created Excel spreadsheet file.  This can be done by creating a table within Excel and using the file filters.  

To create a table within Excel, highlight the columns that contain the data and on the "Home" ribbon tab, in the "Styles" panel, click "Format as Table".  Select the desired style for your table and within the "Format As Table" header, make sure the box next to "My table has headers" is selected and click OK.  To filter, you will need to click the "arrow" icon within the header of the table (see image).

Best regards,

[Steve_Bessette]

Here is the image I referred to in my previous post.