Sorting parts list table by function
Is there a way to sort a table by a function based on a part name?
I have a parts lists which is generated using repeat region tables. I need to sort the entries so that those which are designed items and having a name length of 13 characters appear first and then the purchased parts (e.g. screws, handles etc) which have a 7 digit name length appear afterwards. Any file which doesn't have a 7 or 13 character file name is a dummy part/asm and would be manually filtered out, unless I can find a way of automating that as well.
&asm.mbr.name
42345-0001-00
42345-0002-00
42355-0001-00
22-3456
23-2345
34-9865
Designed parts always start with a 4 and stock parts start with a 2 or 3 so the default sort option of "&asm.mbr.name forward" lists parts in the wrong order.
This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.