Remove all the characters and special characters ecpect TBD and digitis

[Demo_User]

Remove all the alphabet and special characters expect TBD and digits

Input: *A-TBD1233567C
Output:TBD1233567

Input:TBD45677G
Output:TBD45677

Input:+TBD48879
Output:TBD44678

Input: BTS-5678
Output:5678

[Sachin_Hatikankan]

Hi,

You can apply below regex and extract the required string pattern
(TBD\d+|\d+)

Regards,
Sachin

[mkankatala (Mahesh Kankatala)]

Hi @Demo_User

Use the Regex Expressions to obtain the result. Please check the below regex expression.

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“[A-Z]+\d+\w*”)

Hope it helps!!

[ppr (Peter Preuss)]

(TBD)?\d+

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum