Inbound emails containing HTML tables in the email body

[Jamsta1912]

Hi all,

I have a number of Inbound actions that process emails from customers. Among other things, the inbound actions typically grab the content of the email body, using email.body_text and put it in the description field of the new task.

Sometimes, customers include tabular data in the email, and it gets converted to text in the descrption field, but usually with a number of blank lines where the ends of table columns and tables would otherwise have been. Here's an example table:

This is some text	REF12345
Purpose of Email	Blah Blah Blah

CI Details
Name	Floor	Location	Address	Post Town/Code
My_CI	A/E	na,na
	B/E

When the text gets added to the description fields, I see several blank rows between 'Blah Blah Blah' and 'CI Details'. I've been trying to remove excess blank rows with   str.replace("\n\n", "") and str.replace("\r\r","") but I can't make them disappear. So I'm guessing the characters causing the blank rows are not actually new lines or carriage returns. Can anyone advise what characters might be being produced in the text where the HTML table tags would otherwise have been, causing the extra rows?

Jamie.

[Prasad11]

Hello SRJ,

Did you get any solution for that HTML table insert into record as a original table into description field.

[Chavan AP]

Hi Please check out my article on this:

https://community.servicenow.com/community?id=community_article&sys_id=8dcdc538db50ccd0d82ffb2439961...

mark it helpful and correct if this resolves your query

Regards

ajay