Data Extraction - Sorting Numbers in the Table

[Jaiyakumar]

Hi,

I have used the Data extraction to do some setting out coordinates in Auto CAD 2016.

After, Added all the information the numbers seems to be not sorted as Ascending.

Can any one tel what is the problem or Should I do add more process to it which I missed?

Please any one help me!!

Screen Shot attached

Sorting Number in Data link

[imadHabash]

Hi,

is it applicable to share your CAD .dwg file with us here for testing please ? 

[john.vellek]

Hi @Jaiyakumar,

If you have three digits then you need to use 001, 002, 003...format for everything to sort properly.

Please select the Accept as Solution button if my post solves your issue or answers your question.

[Jaiyakumar]

Hi John,

Thanks for your reply.

I gave shot of your solution but by changing the every time the decimal value - it is definitely tired job.

As, In most of our project the number keep on exceeding from three decimal to four decimal in every revision based on the construction process.

Can you suggest me any other solution - any other option to try in Auto Cad, please?

Thanks & Best Regards

[imadHabash]

Hi,

>> Can you suggest me any other solution <<

i suggest to read and follow this link that may help . >> Click <<  

Regards,

[Jaiyakumar]

Hi Imad,

I appreciate your effort to reply to the issue.

I have attached the .dwg, Data EXtraction file (.dxe) and .xl file (I have tried the solution from the link which you have sent me previously- which seems also to be not working).

I am not sure - if there is any problem with the attribute whic make this extraction in a wrong sorting order.

Please have check and let me know your comment on this.

I am eagerly waiting to crack a solution for this issue.

Thanks & Best Regards

[john.vellek · Accepted solution]

Hi @Jaiyakumar,

I do not know of other ways to get this to sort any differently.  You can try using Find/Replace to add the leading 0 to existing attributes to make this easier.

Please select the Accept as Solution button if my post solves your issue or answers your question.

[cadffm]

You only need to set the column to Integer(whole number), because  integer attribute values

(and your "01" what is only a valid string, no number) does not automatically recognize  as numbers.

For real numbers this would be the case.

DataExtract, Right Click to the Column-Header, set Column data format...

Or did I not understand the problem?

[Jaiyakumar]

Hi @cadffm,

Thank you for your reply in this issue.

I will have quick try and check on this and come back to you.

Thanks