Skip to main content

Hi, I have an email which with the following content. I would like to extract 

“First Name, Last Name, ARD Name, Password, Email Address” to a Google sheet.

+++++++++++++Begin+++++++++++++

From: HR Department <tester@blueforestintl.com>
Date: Mon, Jan 23, 2023 at 12:57 PM
Subject: Ticket Assigned - Connect Report - ADR Staff Added - Blue Forest International (Department)
To: <tester@blueforestintl.com>

Connect Report - ADR Staff Added - Blue Forest International (Department)

Locker Connect Message from Blue Forest International (Department).

Results: (plain text results below table)
First Name    Last Name    ADR Name        Password    Email Address
Active        Directory1    adirectory1    Pass123        adirectory1@blueforestintl.com
Active        Directory2    adirectory2    Pass123        adirectory2@blueforestintl.com
Active        Directory3    adirectory3    Pass123        adirectory3@blueforestintl.com
Active        Directory4    adirectory4    Pass123        adirectory4@blueforestintl.com


First Name, Last Name, ADR Name, Password, Email Address
Active,DIRECTORY1,adirectory1,Pass123,adirectory1@blueforestintl.com
Active,DIRECTORY2,adirectory2,Pass123,adirectory2@blueforestintl.com
Active,DIRECTORY3,adirectory3,Pass123,adirectory3@blueforestintl.com
Active,DIRECTORY4,adirectory4,Pass123,adirectory4@blueforestintl.com

https://blueforest.intl.com/helpdesk/tickets/56712

 

+++++++++++++End+++++++++++++

Thank you

Hi @wkc 

Good question.

Guidance: