Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

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
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

2 Replies
CatalinaS
Dataiker
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

UN
Level 2
Author

Thank you so much!!

0 Kudos