How to extract a number from a particular string

[Bhagyashree_S]

Hi team,

How to extract only number present in the text .
And the text may vary.

Regards,
Bhagyashree

[rlgandu (Rajyalakshmi Gandu)]

@Bhagyashree_S

Please put the input and output samples

[Anil_G (Anil Gorthi)]

@Bhagyashree_S

If the number does not have points or comma use \d+

If it has points \d+\.\d+

If it has comma also then [\d,]*\.\d+

Cheers

[Bhagyashree_S]

How to use regular expression…we need to pass it on assign activities right?

[Anil_G (Anil Gorthi)]

@Bhagyashree_S

You can use matches activity or use assign as below

Requirenumberstring = System.Text.RegularExpressions.Regex.Match(InputStringVariable,"\d+").Value

Cheers

[rlgandu (Rajyalakshmi Gandu)]

@Bhagyashree_S

StrOutput=System.Text.RegularExpressions.Regex.Match(currentItem.ToString,"[\d\,]*\d+\.?\d*").Value

[Parvathy (PS Parvathy)]

Hi @Bhagyashree_S

You can try the below syntax:

Output= System.Text.RegularExpressions.Regex.Match(Input,"\d+[.,]?\d*[.,]?\d*").Value

Hope it helps!!

[mkankatala (Mahesh Kankatala)]

Hi @Bhagyashree_S

Try to extract with the Regular expressions, Check the simple below expression,

[\d\,?\.?]+

You can check in the regexr.com

For Example -

- Assign -> Input = "For the Meeting 8,750 memebers attended"

- Assign -> Output = System.Text.RegularExpressions.Regex.Match(Input.ToString,"[\d\,?\.?]+").Value

Check the below workflow for better understanding,

Hope it helps!!

[lrtetala (Lakshman Reddy)]

Hi @Bhagyashree_S

Can you try the below

InputString="Hello world! 1234 How are you?"
Output=New String(InputString.Where(Function(c) Char.IsDigit(c)).ToArray())

Cheers!!

[Bhagyashree_S]

Thank you so much …it worked