Email Extraction Process

danniaus1

New Member
Hi Everyone

I am pretty new to Blue prism and have a question about extracting specific data from an email body

As an example the email I received contains the following

Customer Details

Site Name: Blue Prism Test
Site Address: Blue Prism Lane, Water, Vic, 3016
ABN: 89 411 555 555
NMI: 3111111111

Billing Details

Billing Contact Name: Blue Smith
Billing Phone: (07) 1234 5678


I would like to extract the following:

Blue Prism Test, 89 411 555 555

The format in which the emails are sent is the same but the names, addresses ABNS, nmis will all differ.

What is the best way to go about this? I am not very familiar with Regex, any help would be greatly appreciate.
 
Top