Page 1 of 1

Function SPLIT() doesn't work?

Posted: Tue Oct 08, 2019 2:53 pm
by Vivien
Hi,

I need to split a date to get only the year. My dataframe has a column Date and I tried to compute or transform variable with function SPLIT() in the category "Text" in the selection list button "fx", but it doesn't work. I don't understand why, despite the help (cf. png in attachment)... Is it a bug or an oversight on my part?

exemple of value in variable "date": 23/01/2015

Transform function:
fx = SPLIT(date,sep='/',3)

Thank you for your help.

Re: Function SPLIT() doesn't work?

Posted: Tue Oct 08, 2019 8:42 pm
by MAgojam
Hi, Vivien.
Take a look at the screenshot I enclose, where I use "Computed Variable" and the SPLIT () function.
ScreenShot_SPLIT.png
ScreenShot_SPLIT.png (34.31 KiB) Viewed 2460 times
Cheers.
Maurizio

Re: Function SPLIT() doesn't work?

Posted: Wed Oct 09, 2019 8:11 am
by Vivien
Ok!!! Thanks for your help Maurizio!!!