Specific List/String Filtering

[Vykr]

All,

I’m struggling to find a way to isolate certain disciplines based on our job numbering system.

Such as “ARP-ZZ-XX-DR-E-25000”
What I want to do, is isolate the “E” as that determines the discipline (being electrical)
I was doing okay with it being M and E as per the script below, as they didn’t have any letters elsewhere in the drawing number, however when trying to filter “P” as per the image below, I have issues because the first part to our drawing number is ARP

Is there any way I can ask it to isolate the “E” and focus on that?

I hope that makes sense… If not find the attached script below,

Any help would be appreciated.

EDIT: The script is quite a mess… I can’t find a way to make it less.

Drawing Register Create Sheets.dyn (732.1 KB)

[Mohammad_Nawar]

why you don’t Search for -P- instead of only P.

[Vykr]

Geeeee, thanks! Too early in the morning for Dynamo…

I have another question that I’m not sure if you can help with…
For some reason, when my script runs it creates “Unnamed” sheets, I’m not sure how to remedy this issue, the excel file i’m working from has everything named correctly, it seems to be creating new sheets.

EDIT:An example from that image M-24008 should be named as M-24009 is named, but M-24009 doesn’t exist.

EDIT2: Not sure why there are Nulls?!

[Andreas_Dieckmann]

Your sheet names most probably contain illegal characters: