Custom ticket rule to get substring of HD_TICKET.TITLE
So, my title of my custom onboarding queue ticket contains the following
New Employee Enrollment * Testor Altestorosa * 2-23-2022
With the new employee name between the "*" characters, in this case "Testor Altestorosa"
I want to select only the user name from this title, into a variable that I can then have CTR automatically fill a custom field with the informaiton...
So far I have this as a select
HD_TICKET.TITLE, -- $title
SUBSTRING_INDEX(TITLE, "*", -2) as Result,
'My-Emailaddress.com' AS NEWTICKETEMAIL -- $newticketemail
HD_TICKET.HD_QUEUE_ID = 22
and I have an e-mail set to send info to NEWTICKETEMAIL with the variable $result
and the result in my e-mail was "Testor Altestorosa * 2-23-2022"
so my question is how can I do this to remove the info starting with the 2nd "*" ???
any suggestions are much appreciated!