Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Extract only numbers from a mark with numbers and letters

5 REPLIES 5
SOLVED
Reply
Message 1 of 6
ryley.g.h
514 Views, 5 Replies

Extract only numbers from a mark with numbers and letters

ryley.g.h
Advocate
Advocate

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?

 

ryleygh_0-1643728318269.png

 

0 Likes

Extract only numbers from a mark with numbers and letters

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?

 

ryleygh_0-1643728318269.png

 

5 REPLIES 5
Message 2 of 6
RDAOU
in reply to: ryley.g.h

RDAOU
Mentor
Mentor

@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

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


0 Likes

@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

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Message 3 of 6
ryley.g.h
in reply to: RDAOU

ryley.g.h
Advocate
Advocate

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.

0 Likes

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.

Message 4 of 6
RDAOU
in reply to: ryley.g.h

RDAOU
Mentor
Mentor

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!

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


0 Likes

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!

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Message 5 of 6
ToanDN
in reply to: ryley.g.h

ToanDN
Consultant
Consultant
Accepted solution

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

0 Likes

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

Message 6 of 6
ryley.g.h
in reply to: ToanDN

ryley.g.h
Advocate
Advocate

That work-around will work, thanks!

0 Likes

That work-around will work, thanks!

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report