Essentially your pattern is wrong You are matching ALL of the input string (“of 850”).
The second set of quotation marks (“of (\d+)”) is the ‘Regex pattern’. The brackets just create ‘groups’ within a Regex Pattern. Groups allow you to easily capture components of a bigger string like a year, month and date separately (see below)
Regex Pattern with Groups:
Results with Groups:
If you just need “850” as the result/output then update it to “\d+”. If you want it in group 1 then update the pattern to “(\d+)”.
I would highly recommend using the below template with an Assign activity:
- The italics is where you should place the input string variable.
- The bold is where you should insert the Regex Pattern.
- Note this will only match the first result only
Hopefully this helps you