Extract number from string

  1. Refined Sunflowerseed Oil 136,000 2.26 133,000 -9.33 150,000 45.20 93,667

I want to extract the numbers from the above string and to get average of them as a final result.

Hi @Bhageswar_Yadav

There multiple ways you can capture the numbers but easy to use are

  1. regex expression “\d+” will capture all the digits in the string
  2. iterate through each character in the string and to check if it is a number by using IsNumeric() function

hope this is helpful

Hi @Bhageswar_Yadav
Use regex condition to extract a number in the string

Iterate through each character in the string and using IsNumeric() function
Try this and it works

using regex i am getting space separated 136,000 as 136 … and 2.26 as 2 and 26 different number
can you please provide solution to it

Hi

how to get the integer value by removing (,) from 136,000

Use this Regex

from entire string 5. Refined Sunflowerseed Oil 136,000 2.26 133,000 -9.33 150,000 45.20 93,667 if i want to get the string after substring Refined Sunflowerseed Oil and want this as output 136,000 2.26 133,000 -9.33 150,000 45.20 93,667 ?

Use this regex to get the output