Extract only numbers from a mark with numbers and letters

[ryley.g.h]

On our door schedules, we like to have a breakline between the different groups of 100's (100, 200, 300, ect). We are currently just using a hidden comment field to group, but I'm curious if there's anyway to automate this? If I was able to extract just the "500" value, as a number, from door mark of "500A" I could do it, but I can't figure out how to do that. Does anyone have any ideas?

[RDAOU]

@ryley.g.h 

If you clarify the criteria behind the various groups of hundreds, you would make it easier instead of one guessing. Example: if Mark groups are related to levels (ie: 000s = GF, 100s = L1, 200s = L2...etc)then you do not need comment. Group by level

Apart from the above, what do you want to Automate what exactly? inputting the comment?

1. Filter using Mark "Begins with" - Uncheck itemize .... Fill in the Comment once for all 100s (repeat)
2. Otherwise if Mark is not related to level and too lazy do the filter and fill, use dynamo to sort and set value of the comment accordingly

[ryley.g.h]

The door marks are based off of a rooms number. If room number 200 has 5 doors, they are labelled as 200A, 200B, 200C, ECT. The issue is most people are forgetting that the comment field is hidden and is what controls the grouping... no matter how many times they are shown.

If I was able to get just the numbers out of the door mark, I could easily setup a rounding calculation that would act as the comment field, and the schedule will automatically do the grouping for us.

[RDAOU]

Ok... what drives the room numbers? Are all 200s rooms on level 2 and all 300s on level 3? And 400s level 4...etc

=> Sort door Schedule by level >> Set a header of footer => get the break for each group of hundred/level!

[ToanDN · Accepted solution]

Why don't you add Room number field and sort by it?

[ryley.g.h]

That work-around will work, thanks!