I am trying to use the following code where Region1 is a string variable
RegLen = length(Region1);
if substr(Region1,RegLen-7,8) = "Division" then
Region2 = cat(Region1," Support");
For some reason this won't work and the error occures at 'RegLen-7' in the substr function. when I replace this with a number, 14 for example' it works, but as Region1 can be any number of characters long I need this calculation in there.