Hallo, I want to extract these C and P numbers from the body of the email, they are categorized like that how can I use regex and flowchart so that the bot can extract anyone of these if they are on the body of the email:
For example, anything that has a pattern of AAH/AHPM , take that as a C number and so on. I want to use flowchart not nested IF condition as it may get complex …
Please see below:
1 Like
C Number Regex: AAH/\w+|AHPM/\w+
P Number Regex: AAP/\w+|AHPP/\w+
Use Regex Matches activity with emailBody as input and the pattern. Access result like: matches(0).ToString.
If you found helpful please mark as a solution. Thanks
Happy Automation with UiPath
1 Like
Hi this will work but I have different groupings of these C and P numbers from an excel file, so I will need to group them.
What I also need help with..after I have extracted the pattern from outlook email, I need to match it with the list of C and P numbers from an excel file to choose which one is it from the list in the file. example:
From email they come like this:
I then check amongst this list and extract accordingly:
Here is another example of outlook email:
So I have to extract that alphanumeric value and go look for it on the excel file then and extract and put it on the system.
On this first email, I need to extract:
This is what is coming up when I do regex, it’s seperating it into 2:
Instead of “|” , use \s
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.