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
View original