Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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!
Hi @UN ,
You can extract the right 3 characters of the data using a Prepare recipe and the formula
substring(line,-3)
Hi @UN ,
You can extract the right 3 characters of the data using a Prepare recipe and the formula
substring(line,-3)
Thank you so much!!