Extracting price from text using regex replace

[Derek++ 0]

Hi,

 

I'm trying to extract the price from this text...

<span class="star"></span>  1973 Land Rover 88 NUT & BOLT RESTORATION - $65000 (PALM BEACH )</h2>

BTW "$" is the html escape code for the dollar sign. I'm using this code...

set(#price, $replace regular expression(#fulltitle, "^.+$([0-9]+).*$", "$1"), "Global")

Where #fulltitle is the input text from above.

 

The regex works perfectly in Editpad Lite but not in ubot. I have tried several different variations but nothing seems to work. Also if I just use a regex like this...

set(#price, $replace regular expression(#fulltitle, "^.*([0-9]+).*$", "$1"), "Global")

Then I will end up with only the last digit "0" instead of the whole group "65000". What am I doing wrong?

 

[ds062692 19]

Why don't you use find regular expression instead of replace regular expression? In this case find regex is much more convenient.

[Code Docta (Nick C.) 638]

Need to use .net Regex

 

http://regexhero.net/tester/

 

works in version 4 sometimes five

 

set(#price, $find regular expression("<span class=\"star\"></span>  1973 Land Rover 88 NUT & BOLT RESTORATION - $65000 (PALM BEACH )</h2>", "(?<=$).*?(?=\\s)"), "Global")