Extract Numeric data from Alpa Numeric string

[prerna.gupta]

Team,
I need to extract all numbers of an alpha numeric string, kindly suggest.
str_InputString(data type is String) = “1742cookm”
str_Output(pls specify which data type) - 1742
Thanks in advance.

[rlgandu (Rajyalakshmi Gandu)]

@prerna.gupta

System.Text.RegularExpressions.Regex.Match(InputString,“\d+”).Value

[vrdabberu (Varunraj Dabberu)]

@prerna.gupta

Hi please use the below regex expression and assign it to a variable and the output variable type must be a string.

System.Text.RegularExpressions.Regex.Match(InputString,"(\d+)").Value

Hope it helps!!

[prerna.gupta]

@rlgandu

System.Text.RegularExpressions.Regex.Match(InputString,“\d+”).Value

I tried this already but its an Error.
str_Output data type = System.Text.RegularExpression.MatchCollection

[rlgandu (Rajyalakshmi Gandu)]

@prerna.gupta

The datatype of match is string

Assign str_Output data type to “String”

[prerna.gupta]

Datatype of Match ?
str_InputString(data type is String)
str_Output - Can you specify the adta type again ?

[vrdabberu (Varunraj Dabberu)]

@prerna.gupta

Extract Numeric data from Alpa Numeric string

@prerna.gupta Hi please use the below regex expression and assign it to a variable and the output variable type must be a string. System.Text.RegularExpressions.Regex.Match(InputString,"(\d+)").Value [image] Hope it helps!!

Please try the above flow

Regards

[rlgandu (Rajyalakshmi Gandu)]

@rlgandu

Assign str_Output data type to “String”

@prerna.gupta

Assign str_Output data type to “String”

[prerna.gupta]

@Extract Numeric data from Alpa Numeric string

System.Text.RegularExpressions.Regex.Match(InputString,“(\d+)”).Value

This worked.
Thanks much for such quick resolution.

[vrdabberu (Varunraj Dabberu)]

@prerna.gupta

below is the attached xaml for your reference
Sequence.xaml (8.3 KB)

Hope it helps!!

[vrdabberu (Varunraj Dabberu)]

@prerna.gupta

Thank You

Happy Automation!!