Forum Discussion
Extracting text removing html/tags and user signatures
Hi experts
Hope you can help me!
I have a support ticket system that has the issue extracted into one column by ticket.
The ticket includes HTML, a users email signature and other text I need to strip out. In affect I am looking just for the plain description.
See attached example with column B my desired output.
Note that there are two methods that create the data. One is the user utilising a standard template where the description is clear e.g. Description: xxxxxxx
Another method is we recieve the data without this mentioned. I have included examples of both scenarios in the file.
Is there a reliable formula to basically extract into column B just the ticket description?
Note - Macros is not an option sadly due to workplace policies
Thank you!
3 Replies
What you need is substring from begin to | or {,is it right?
if so,try regextract https://support.microsoft.com/en-us/office/regexextract-function-4b96c140-9205-4b6e-9fbe-6aa9e783ff57
^[^{|]+?(?=[\|\{])
select Issue,regexp2('^[^{|]+?(?=[\|\{])',Issue) result from Sheet1;
Thank you for your reply. I think this function is not available in my workplace yet - looks like a BETA only. Are there any other options as this would have been ideal!
