Remove special characters at the string

[Demo_User]

*ABH445677-BH
These special characters will varu
Need to remove special character at front
And remove special character at end along with the preceeding characters

Output:
ABH445677

[arjunshenoy]

Hi @Demo_User

You can use the following RegEx for the same:

\b([A-Za-z0-9]+)-[A-Za-z0-9]+\b

Hope this helps,
Best Regards.

[Demo_User]

Returning blank value

[arjunshenoy]

@Demo_User

Well, in that case, you can use this pattern:

\b([A-Za-z0-9]+)

UiPath syntax will be like this:

outputData = System.Text.RegularExpressions.Regex.Match("ABH445677-BH","\b([A-Za-z0-9]+)").Groups(0).ToString

Hope this helps,
Best Regards.

[V_I_S_W_A]

@arjunshenoy

outputData = System.Text.RegularExpressions.Regex.Match(“ABH445677-BH”,“\b([A-Za-z0-9]+)”).Groups(0).ToString

I hope this should work - Such a brilliant one.

[Parvathy (PS Parvathy)]

Hi @Demo_User

Try using the Regex expression:

[A-Z0-9]+(?=-)

Hope it works

Regards,

[Anil_G (Anil Gorthi)]

@Demo_User

Another way

System.Text.RegularExpressions.Regex.Match(str,"\w+").Value - this will get only first matched so would get the exact string

Cheers

[mkankatala (Mahesh Kankatala)]

Hi @Demo_User

You can use the regex expression to extract the required data.

Hope it helps!!

[vrdabberu (Varunraj)]

Hi @Demo_User

Try using the below regex expression
(?<=.?)([A-Z]+\d+)(?=.?)