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
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: (?<=[]).(?==)
Regards,
Nived N
Happy Automation
1 Like