I am trying to get the umber from the string but getting the “Invalid Syntax - One of its operands is invalid.” error, will someone help me with this.
substring('Your request to Terminate for Test User ID number 12345',indexOf(length(replace('Your request to Terminate for Test User ID number 12345 has been approved and has completed','has been approved and has completed','')),'number',0)
)
Best answer by Daniel Söderlund
I am trying to get the umber from the string but getting the “Invalid Syntax - One of its operands is invalid.” error, will someone help me with this.
substring('Your request to Terminate for Test User ID number 12345',indexOf(length(replace('Your request to Terminate for Test User ID number 12345 has been approved and has completed','has been approved and has completed','')),'number',0)
)
You posted this in the Freshdesk forum :)
Is the string fixed ?
Just like to remove the tex in front of the number?
If it’s that you can do like this
{{ticket.subject | remove: ‘Your request to Terminate for Test User ID number ’ }}That will give you the number only.
With expression I should dom something like this
substring('Your request to Terminate for Test User ID number 12345',
indexOf('Your request to Terminate for Test User ID number 12345',
'number ',0)+length('number '),
length('Your request to Terminate for Test User ID number 12345')
)
+14I am trying to get the umber from the string but getting the “Invalid Syntax - One of its operands is invalid.” error, will someone help me with this.
substring('Your request to Terminate for Test User ID number 12345',indexOf(length(replace('Your request to Terminate for Test User ID number 12345 has been approved and has completed','has been approved and has completed','')),'number',0)
)
You posted this in the Freshdesk forum :)
Is the string fixed ?
Just like to remove the tex in front of the number?
If it’s that you can do like this
{{ticket.subject | remove: ‘Your request to Terminate for Test User ID number ’ }}That will give you the number only.
With expression I should dom something like this
substring('Your request to Terminate for Test User ID number 12345',
indexOf('Your request to Terminate for Test User ID number 12345',
'number ',0)+length('number '),
length('Your request to Terminate for Test User ID number 12345')
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
