How to find only alphabets and combination of alphabets and numbers using regex in uipath?

[ASWATHY_K]

for example my string is
"WINDOW HOST WITH MS 00440452 1 2900.00 0.00 2900.00 18.00 0.00 0.00 522.00 3422.00 SQL123 DB "
here i want only alphabets and combinations of alphabets and numeric.
Anyone pls help

[Gokul001 (Gokul Balaji)]

Can you share the expected output? @ASWATHY_K

[Gokul001 (Gokul Balaji)]

Hi @ASWATHY_K

Here you can try with Regex.Replace method

System.Text.RegularExpressions.Regex.Replace(YourString,"\d","").ToString

It will get only the alphabets in the input string

Regards
Gokul

[ASWATHY_K]

WINDOW HOST WITH MS SQL123 DB
This is the expected output

[Yoichi]

Hi,

Hope the following helps you.

\b([A-Za-z]+|[A-Za-z\d]*(\d[A-Za-z]|[A-Za-z]\d)[A-Za-z\d]*)\b

Regards,

[varunk (Varun Kumar)]

@ASWATHY_K

Try with this below pattern it will work your scenario

Thanks
Varun

[ASWATHY_K]

Only get the first value Window

[ASWATHY_K]

Only get the first value “Window”

[ASWATHY_K]

alphabets get correctly then how to find the combination of alphabets and numeric like
“SQL123”
Pls help me

[Yoichi]

Hi,

Do you need to get single string as result? If so, the following will work.

String.Join(" ",System.Text.RegularExpressions.Regex.Matches(yourString,"\b([A-Za-z]+|[A-Za-z\d]*(\d[A-Za-z]|[A-Za-z]\d)[A-Za-z\d]*)\b").Cast(Of System.Text.RegularExpressions.Match).Select(Function(m) m.Value))

Sequence3.xaml (4.9 KB)

Regards,

[Sudharsan_Ka]

HI @ASWATHY_K

Try this expression

System.Text.RegularExpressions.Regex.Match(YourString,"\D+(?=\s\d)").ToString+" "+System.Text.RegularExpressions.Regex.Match(YourString,"[A-Z]+\d.+$").ToString

Regards
Sudharsan

[ASWATHY_K]

Thanks .
This is exactly what i want ,Thank you