Hi, I’m trying to sort a bunch of sheet numbers, by sheet string number length then by alaphabet and number. eg. A1 A2 A3 R1 R2 A101 A102 A103 A104 RC21 RC22 RC23 S101 S102 S103 A1001 A1002 A1003 A1004 [image]

You’ll probably have to take certain aspects of your sheet numbers and use List.SortByKey. For example, if you take the first character of each sheet number, you can use List.SortByKey (or even List.GroupByKey to isolate the sheets for each discipline. Then, you can group each of the sheets within a…

Check this, Orchid may help. [image] Sorting sheet list for export to Excel Revit Check out the Orchid package. I believe @erfajo has a couple ‘natural’ sorting nodes that may just help you.

that’s how you can do it [Capture]

Thanks. I think this is making the most sense but I’m not sure I can get my element values to match the keys at the end. I dont think itll be sorting the elements the same at the end. [image]

This didn’t actually work either. Need to list sort sheet number before combining the sheet number and name. Which means I need to sort the sheet name to the sheet number somehow

You’ll have to do multiple List.GroupByKey operations. The first will group your sheet numbers by their length, the second will group each of the resultant groups by their prefixes (I believe Clockwork has some regex nodes. The regex pattern here would be ‘\w+’ to get one or more word characters in …

@vanman once the names are sorted, it is easy to retrieve the corresponding sheets [Capture]

Thanks man, But whats the key I would sort by after grouping by length? Keep getting this annoying layout for the sheet list. [image] [image]

Get the first character of the string (using String.Substring) then sort by that.

List sort by sting length then value

SeanP October 2, 2019, 3:34am 3

Check this, Orchid may help.

Topic		Replies	Views
Sort list based on sheet number with element ID Lists-Logic	7	1128	November 15, 2018
Re-orgranize a list of sheet instances using sheet number parameter (A-9,A-10,A-11, etc...) Revit	2	413	February 6, 2019
Sorting sheet list for export to Excel Revit	4	1623	February 23, 2019
Sort a sheet list by 3 parameters Revit revit	3	137	August 25, 2023
Re-arrange sheet elements on a list based on sheet number Revit	2	730	January 18, 2018

List sort by sting length then value

Related topics