Regex help?!

From this:
\n\t\t \t\t\t1.500 kr / 0 kr rep

i want 1500.

how should i do? this isnt working =/

1 Like

If NewStr is the extracted string and OldStr is the example string above, assign NewStr as:

System.Text.RegularExpressions.Regex.Match(OldStr, "\d+\.\d+").Value

Or you can use \d+\.\d+ in your regex for the Match activity.

Then you need to replace NewStr with NewStr.Replace(".", String.Empty) + ".".

2 Likes

Hi
Hope you are doing good
if this is the input stored in a variable named strinput
then use a assign activity with output variable will be like this
stroutput = System.Text.RegularExpressions.Regex.Match(strinput.ToString,“[0-9.]{2,}”).ToString.Trim.Replace(“.”,“”)

Cheers @Doktorgud

4 Likes

You are a star as always, thanks!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.