Getting value of a string between two specific characters

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.


We can get them using Matches activity as the following.

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

Sequence.xaml (6.2 KB)


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

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