Custom Translate Function

[moodymage]

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 function but I can't find a record of it.

I would appreciate any help in getting this function recreated in our v8 instance

[Amine_Abedour]

Hello @moodymage,

Please check in your V7 instance if theire is any extension of funcList in xtk:funcList schema. Your translate function is probably declared theire.

If it is the case, you can export the extension in a package and import it in your V8 instance.

You can find more infos here  

Br,

[moodymage]

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

[Amine_Abedour]

Hi @moodymage,

Is it possible to share with us an example of its use (is it used in an enrichment activity, in JS activity...)?

Br,

[moodymage]

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)