I'm trying to parse an email to an Excel table and I'm having a heck of a time with this.
The email is one of those forms with name, address, phone, etc. Unfortunately this form when emailed isn't in a nice easy format. It's just a big ball of text.
So instead of something nice like:
Name: name
Address: address
Phone: phone
Here is what I have to parse and what I need to pull:
Name John DoeAddress 1234 State Rd
CityName, IN 12345
Map It
[https://us-east-2.protection.sophos.com?d=google.com&u=aHR0cHM6Ly9tYXBzLmdvb2dsZS5jb20vbWFwcz9xPTQyMjMrUGluZXMrUmQrUGFkdWNhaCUyQytLWSs0MjAwMQ==&i=NjIxNjk0MTY0Njg5MTcwZjM1MDQ4NTlj&t=Qzg3QXVnWGVGSkhOMlZvVVUzbVdVYjY4M3c2aFVSemIrbTBialFlbzlYMD0=&h=5bf5d12746274218ac6405001d549d1d&s=AVNPUEhUT0NFTkNSWVBUSVYdezzyoxQHANtG2Vn0DLx0dNf3R4EDjq4IiQdsOGBY9A]Phone 4105559874Email JohnDoe@gmail.comCurrent
Internet Provider ComcastWhen does your contract with your current internet
provider end? July 2025
These all go into an Excel table which is the easy part.
I have the email connector working as well as HTML to text action.
I'm having a real hard time understanding the syntax and how this split function works even after reading about 100 blogs on it. Still isn't clicking for me at all.
Any ideas?