Function SPLIT() doesn't work?
Posted: Tue Oct 08, 2019 2:53 pm
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.
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.