excel function RIGHT() on Dataiku

Solved!
UN
Level 2
excel function RIGHT() on Dataiku

Hi, 

I am trying to find a way to use LEFT() or RIGHT( )  formula (that we use in excel) on dataiku. Is there an equivalent formula that I can use? 

I have values in one of the columns from which I want to extract the right 3 values. example: m230, I would like a new column with the value 230. 

Appreciate any help on this. 

Thanks! 

0 Kudos
1 Solution
CatalinaS
Dataiker

Hi @UN ,

You can extract the right 3 characters of the data using a Prepare recipe and the formula 

substring(line,-3)

 

Screenshot 2022-08-25 at 10.43.15.png

View solution in original post

4 Replies
CatalinaS
Dataiker

Hi @UN ,

You can extract the right 3 characters of the data using a Prepare recipe and the formula 

substring(line,-3)

 

Screenshot 2022-08-25 at 10.43.15.png

MCharlotte
Level 1

if I want to extract the left 3 characters of the data, how do I do this ?

 

0 Kudos
CatalinaS
Dataiker

You can extract the left 3 characters with the formula:

substring(column1, 0, 3)

Screenshot 2023-05-19 at 17.00.54.png

โ€ƒ

0 Kudos
UN
Level 2
Author

Thank you so much!!

0 Kudos