New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

how can we count digit

dave
Level 1
how can we count digit

Hello,

How can we have the formula if we would like to confirm for any particular field name must have only 7 digit then 1 else 0 in dataiku dss?

 

 

0 Kudos
1 Reply
Mattsco
Dataiker
Dataiker
 

Hi, 

You can use the "extract with regular expression" processor with this pattern ^\d{7}$

And check the box "Create a special column found". 

 

 

 

Mattsco
0 Kudos
Labels (1)
A banner prompting to get Dataiku DSS