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.