Hello community ;), anyone know how to create a function for Mobile Phone Number, where the only valid first digit is 6 or 7 and the rest convert to N/A. thanks in advance!

[Trifacta_Alumni · Accepted solution]

Hi @juan sánchez? you can do this with Edit column with a formula:

Column -> mobile number

Formula -> IF(MATCHES($col, `{start}6|{start}7`), $col,'N/A')

Best,

Vardan

[TrifactaUsers]

Love it! hundred of thanks Vardan! Do you know where i can learn all trifacta forms of formulas? thanbks in advance!

[Trifacta_Alumni]

Thanks Juan glad you find them helpful. I think the broader question is how you want to apply the features of Trifacta in your data preparation experience and the complexity of the use-case.

From a learning perspective i would say earn your Wrangler and Knight certification that are the foundations. A good place to learn the concepts, features and functions in depth is definitely Trifacta's documentation. There are many sources of public data available today that you can utilize to master Trifacta's functions.

[Trifacta_Alumni]

(Psst! Hey, Community members! If someone answers your question really well, consider marking their response with 'Best Answer'!)