Hi guys,
i've some problems with using the "extract regex values".
I need to extract only number inside my string values.
EX. --> 998,145lb $ i need to extract 998145.
I've found this pattern "\d+(\.\d{1,2})?" and i have 2 matches 998 and 145.
Is this pattern correct? I've tried with the test regex and the match is True but when i try to configure the extract regex values the collection is empty.
So, my goal is to extract this text from a collection field (inside a loop) and then re-insert the correct data inside my collection, which is the best method to do that?
Thanks in advance
------------------------------
Vrat Himbo
------------------------------
Ah, I think I understand what's going on now. The Extract Regex Values action assumes you will pass in a regular expression that uses Named Groups. This is a bit limiting in my opinion because it's basically assuming your input data will always be the same consistent format. In your particular case, this may apply if you're only dealing with prices like in your example. However, if the input data could vary in any way you need more flexibility.
To answer your specific example, you'd want go with a regex like this (?<Group1>\d+)\D(?<Group2>\d+). Then you would want to populate two rows in the Named Values collection and set the Name of each row to Group1 and Group2 respectively. When you run it, the response collection will look like this:
------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------
To answer your specific example, you'd want go with a regex like this (?<Group1>\d+)\D(?<Group2>\d+). Then you would want to populate two rows in the Named Values collection and set the Name of each row to Group1 and Group2 respectively. When you run it, the response collection will look like this:
------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------
@ewilson
Thanks for your reply!
As I was searching for this for hours. It would benefit others if there's a bit screenshots explaining what is discussed here.
1. Set up the Data item
2. Set up a collection with "Fields" and "Initial Values"
3. Set up an action. In the "Regex Pattern", use the correct format "(?<Name (Text)>)RegEx"
* Name (Text), this is what you wrote in the collection initial value
* RegEx, this is normal RegEx pattern
4. The collection will now have 1 matched result
------------------------------
Hao Wu
------------------------------
Thanks for your reply!
As I was searching for this for hours. It would benefit others if there's a bit screenshots explaining what is discussed here.
1. Set up the Data item
2. Set up a collection with "Fields" and "Initial Values"
3. Set up an action. In the "Regex Pattern", use the correct format "(?<Name (Text)>)RegEx"
* Name (Text), this is what you wrote in the collection initial value
* RegEx, this is normal RegEx pattern
4. The collection will now have 1 matched result
------------------------------
Hao Wu
------------------------------
