Skip to main content
Visit Freshworks.com Visit Freshworks

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)
)

 

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') 
)



 

Thanks Daniel it works

Reply


Terms of Use