Your first expression is fine. Just add another single quote, it should be ‘Status’.

Works in my expression builder with the correct single quotes.

Your first expression is fine. Just add another single quote, it should be ‘Status’.

 

Works in my expression builder with the correct single quotes.

 

thank you for taking a look, I hugely appreciate it.  With the single quote added, now I get “Invalid Syntax - Third operand's value must be > second operand's value.”

Please provide a screenshot and the code. 

I don’t understand your last line. Try the following. As this should be easier as third operand in your substring:

length(‘{{ticket.decription_text | sanitize_html}}’)

code from above:

substring('{{ticket.description_text | sanitize_html}}',indexOf('{{ticket.description_text | sanitize_html}}', 'Work email:',0)+length('Work email:'), indexOf('{{ticket.description_text | sanitize_html}}', 'Status', indexOf('{{ticket.description_text | sanitize_html}}', 'Work email:',0)) )

The expression works as expected. But if it cannot find “Status” the indeOf returns -1 and the last operand cannot be smaller as otherwise the expression(substring) is being created from character 3 to -1 which is not possible.

Using this string for the placeholder returns the same error as you said:
“adadwad Work email:john@doe.com Sta”

When trying this placeholder I get the correct substring:
“adadwad Work email:john@doe.com Status”

thank you very much, it worked!! I think i was getting myself very confused with the Status thing, there is no such thing I wanted to look for, so i adapted it for what will be shown in a real ticket