Extract numbers between $ symbols

Help
1

I am scrapping price from a website and the price comes out like this $ 9.89 $

How can I extract the numbers between the $ symbols?

3

Hi @HappyHuman,

can you provide a sample example , what you want to extract ?

5

“$8.99$8.99”
“$25.69$25.69 $57.99$57.99”
“$3.11$3.11 $5.99$5.99”
“$6.97$6.97 $9.35$9. 35”

Here are 4 samples. I want to extract the numbers between the first 2 $ signs.

6

Hi @HappyHuman,

Use the below regex

image

and you can test in regex101.com

2 Likes
7

hi @HappyHuman
try this:
text1 = text.Split({“$”},StringSplitOptions.None)(1)