Outlook pull data from outlook

hi team
I get mail from client where the client will provide the project number in subject line and share there cost in outlook mail in unstructured format how could we fetch price from excel like check screen shot like mark yellow

Hi @airwaveexporter
is $192 as specified in the email body is the price need to be extracted?

no i need $4

Hi @airwaveexporter

Extract the email body and store in string variable

Then use use matches activity to extract the given price using the below regex pattern


Regex pattern: (?<=[]).(?==)


Nived N

Happy Automation

1 Like