Regex to find first word that contains number

[Suastrian_Dika (Dika)]

Hi All,

please help to provide regex to find first word from sentence that contains number.

for ex : ZW Sep23 - ZC Dec23 Inter-Product

i want to find : Sep23

Thank you.

[Usha_Jyothi]

please give more clarification for more accurate solution
Usha

[Usha_Jyothi]

syste.text.regularexpression.regex.match(your variable,“(?<=ZW).*(?=ZC)”).value.trim

in assign activity store the above in variable

[Suastrian_Dika (Dika)]

Hi Usha,

The first word ‘ZW’ constantly changes

[Suastrian_Dika (Dika)]

‘ZC’ also constantly changes, I only need the word with number

[Usha_Jyothi]

[Usha_Jyothi]

You can call them by index whichever value you want

[Suastrian_Dika (Dika)]

only the first one, the second is not included

[Yoichi]

Hi,

How about the following expression?

System.Text.RegularExpressions.Regex.Match(strData,"\w*\d\w*").Value

Regards,

[Suastrian_Dika (Dika)]

Hi Yoichi,

it can’t work if the word is double

[supriya117 (Supriya Allada)]

Hi @Suastrian_Dika

[A-Za-z]+\d+(?=\s*\-)

[Yoichi]

Hi,

Did you check it in regex101? regex101 highlights all matched string.
Can you try the following expression? This returns only first match.

System.Text.RegularExpressions.Regex.Match(strData,"\w*\d\w*").Value

Regards,

[Suastrian_Dika (Dika)]

Hi,

okok, thanks for the explanation.

Regards.

[Yoichi]

Hi,

FYI, in regex101, if turn off global option, the first match is highlighted as the following

Regards,

[mkankatala (Mahesh Kankatala)]

Hi @Suastrian_Dika

You can use the below one with regular expression.

- Assign -> Input = "ZW Sep23 - ZC Dec23 Inter-Product"
- Assign -> Output = System.Text.RegularExpressions.Regex.Match(Input.toString,“(\w+\d+)”).value

Check the below workflow for better understanding.

Hope it helps!!