Expression Builder: Extract mail from ticket description_text

Alternatively, you can try passing the output of this expression as an input to another expression and use the expression below:

replace('{{E1.result}}', '\\r\\n','')

@vishal.abraham. I really thought I had already tried that but it works. Thank you. 

On your 2nd option. I had it as workaround. Only you need to exclude the “\” twice :) 

regexReplace('{{E3.result}}','\\\\n\\\\r','')

Great, glad it worked!

[post removed]

I was really happy to find this thread as I am running into the same issue myself, however, I tried the solution here and it doesn’t seem to be working for me. Here is my expression:

substring('{{ticket.description_text | sanitize_html}}',(indexOf('{{ticket.description_text | sanitize_html}}','Preferred Name (if applicable): ', 0)+32),(indexOf('{{ticket.description_text | sanitize_html}}','Last Name',0)))

I tried replacing ‘Last Name’ with ‘\’ as the solution here used, but when I do I just get an error “Invalid Syntax - Missing ).”. Otherwise, I still get the output with ‘\r\n’ at the end.

If anyone happens to see this and can help me out, I’d greatly appreciate it!

And of course 10 minutes later I’m able to answer my own question. If anyone else happens to come across this same issue, I had to use ‘\r’ to get it to function properly without the error. Here is my final expression that worked:

substring('{{ticket.description_text | sanitize_html}}',(indexOf('{{ticket.description_text | sanitize_html}}','Preferred Name (if applicable): ', 0)+32),(indexOf('{{ticket.description_text | sanitize_html}}','\r',(indexOf('{{ticket.description_text | sanitize_html}}','Preferred Name (if applicable): ', 0)))))