excel function RIGHT() on Dataiku
![UN](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar20.png)
UN
Registered Posts: 8 ✭✭✭
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!
Best Answer
Answers
-
Thank you so much!!
-
if I want to extract the left 3 characters of the data, how do I do this ?
-
You can extract the left 3 characters with the formula:
substring(column1, 0, 3)