Hi @Amine_Abedour It's used in a normal enrichment. It's creating a valid flag based on if a field contains text or not iif(LENGTH(LTRIM(RTRIM(TRANSLATE(@mobileNumber , '0123456789' , '')))) > 0, 'N', @mobileNumberFlag)
Hi Amine, I did check there and the only extension I can see is an additional replace function that I had added, there is no other reference to any other additional functions. For reference the Translate function is also not present in the expression builder, but still works in our v7 instance
Hi,We are currently migrating from v7 to v8 and have come across a custom function which was added in v7 but is not in v8. In v7 we are using this function translate(<fieldname>,'0123456789','') To remove all non numeric characters from a phone number. I believe this was added as a custom SQL functi...