excel function RIGHT() on Dataiku

[UN]

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! 

[CatalinaS · Accepted solution]

Hi @UN ,

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

substring(line,-3)

[MCharlotte]

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

[CatalinaS]

You can extract the left 3 characters with the formula:

substring(column1, 0, 3)

 

[UN]

Thank you so much!!