Question

Custom Translate Function

Forum|Forum|1 year ago
November 13, 2024
1 reply
940 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Amine_Abedour

Community Advisor

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,

Amine ABEDOUR

M

moodymageAuthor

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

Community Advisor

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,

Amine ABEDOUR

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded