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 nee...
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!
