Hi I am trying to find a way to set Workout_Code to a part of the Route name.I am trying to do this via the Filter.set(Workout_Code,Route,isset(Route)) works but I want to split off the last string which will become my Workout_Codeset(Workout_Code,Route,isset(Route.split(' ')[-1])) doesn’t work.
Thanks Ale,I have made some progress where the following works
set(Workout_Code,split(Route," ")[2],Route <> "" and Workout_Code ="")with a positive index. Using -1 to get the last element doesn’t seem to work.Any ideas?