- 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.
I want to extract the numbers from the above string and to get average of them as a final result.
There multiple ways you can capture the numbers but easy to use are
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