Getting value of a string between two specific characters

[dr1992]

Hi there,

I am trying to get two values within a string, but I’m unsure how I can isolate these:

EG: The string scrapes as the following and without spaces: £37,239.20£37,295.00 (though the numbers can change) - how would I then get the the two separate numbers (between the two £ signs and then after the second)?

Thanks for your help.

[Yoichi]

Hi,

We can get them using Matches activity as the following.

The pattern is "[\d.,]+"

Sequence.xaml (6.2 KB)

Regards,

[dr1992]

Split(variableName,“£”)(1) & Split(variableName,“£”)(2) did the trick!