The regular expression you provided only handles period (.) character but not forward slashes (/), hence I modified it a bit as shown below:
(?<Date>(\d{1,2})[\.\/]+(\d{1,2})[\.\/]+(\d{4}))
Test Result On Regex101:
To test the same, you can use either of the below two approaches apart from replace regex action as shown below:
Approach 1:
You can use the 'Extract Regex All Matches' action from the latest 'Utility - Strings' VBO at Digital Exchange and use the following regex expression:
Test Result On Object Studio:
Approach 2:
You can use the original action 'Extract Regex Matches' which is present from the prior versions of this VBO and make sure you pass the named values collection with the following schema:
The name values collection should have two columns called as, 'Name' and 'Value' with one row where the 'Name' column cell has the value as Date.
The regular expression pattern would be same as above and upon executing the action you should be able to get the result in the same collection as follows:
------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
