Hi,
I'm trying to get the First Name of a contact from a field by finding the first ' ' in their full name
Any idea why this formula including add() works:
substring(triggerBody()?['05 - CS Contact'],1,add(indexOf(triggerBody()?['05 - CS Contact'],' ') ,-1 ) )
But this without add() gives a 'The expression is invalid' message:
substring(triggerBody()?['05 - CS Contact'],1, indexOf(triggerBody()?['05 - CS Contact'],' ') -1 )
Cheers!
Done! 😁
Hi @OllyH ,
If I solved your problem, could you please mark my reply as the solution? This way I will help more people in the future.😃
Best Regards,
Sunshine Gu
Hi @OllyH ,
Because if there is no function outside ‘-1’, it will be defaulted to a string, which does not meet the requirements of the formula.
If you add the 'add' function, the index position of the first space represented by the space is subtracted by 1.
Best Regards,
Sunshine Gu