Sequential Door Schedule - Sorting with letters and numbers ?

[vincent.dohertyFZ7C5]

Hi, so I recently inherited a project where doors are named with the corresponding level (example L1-01 ) Is it possible for the schedule to bypass the first three digits and sort by the door count in numerical and alphabetical order ? I tried sorting by level first and then sorting by mark but it still will not display sequentially. 

[barthbradley]

So sorting by the value after the dash? What about filtering rules =Contains "-1", =Contains "-2". =Contains "-3"?   

[ToanDN]

What are you sorting by based on that screenshot?

[syman2000]

Are you sure those door number are reference to the parameter mark or it is reference to a custom shared parameter? It would be nice if you can post screenshot of the schedule and the parameter used.

[luisPDAN6]

You can do a text replace using the app Database Editor. Just replace L1- with nothing in the column mark.

There is a trial in the Revit app store. 

https://apps.autodesk.com/RVT/en/Detail/Index?id=5058771955362580361&appLang=en&os=Win64

[RDAOU]

@vincent.dohertyFZ7C5 

Most probably the title in the schedule may have been changed making you think it was the Mark.  Otherwise that column/field would have been the Mark, the schedule would/should have been sorted in a sequential (ascending/Descending) manner...

Select any Cell in that column and check its properties to verify which field/parameter it is... similar to below image. If that is the case, then simply

1. Go to Formatting tab,
2. HIDE that Field/parameter (ex: in the image below its Level Prefix)
3. and un-hide that of the Mark