Parsing email body into Inbound Email Action

[StewartFletcher]

Good day,

I'm trying to figure out how to get data out of a table in an email, and I've scoured multiple articles and utilised this already - How to read body text in Inbound EMAIL Flow - ServiceNow Community

However, it doesn't work for our instnace because the emails come in a tabled format, with no colons or anything defining the end of a word. Example -:

Title
First name	Test
Last name	McTest

When I tested the parsing utility in our sandbox, I was sending emails in and putting a - between Title and whatever the title is, and it would find it. However, we cannot re-format these emails (there's no option for us to do this without significant development time from another team) so I'm having to try and find a solution to this.

Could anybody suggest how we can achieve this please? I've seen various articles with scripts etc, but none of them work for us.

[Ankur Bawiskar]

@StewartFletcher 

this article should help you, remember your script will only work if the incoming email always follow that HTML table format.

If they deviate then your logic will break

Get the values from HTML table from an email in a Inblund Action 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[StewartFletcher]

It doesn't as that example table has : after each item, ours doesn't

I even tried manually amending the email to put : after the item and it didn't work. It works if I type out Title -  outside of the table, but not in the table.

[Ankur Bawiskar]

@StewartFletcher 

I believe you will require string manipulation in order to cater to your requirement.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[StewartFletcher]

Any assistance you can provide with that at all please?