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!

Catalina

Hi @UN
,

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

substring(line,-3)

UN

Thank you so much!!

MCharlotte

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

Catalina

You can extract the left 3 characters with the formula:

substring(column1, 0, 3)