Is it meant that “RemoveQuotes” doesn’t work when there is a space before or after the separating character, or at the beginning/end of the string?
My datasets can come with or without spaces
st.SetValue(' <January> , <February> ')
you need this:
st.Split(’,’,’ <<-<<’,’> ->’,TRUE,’-’)
what that is specifying is that you have TWO sets of quotes, either with or without spaces. Perhaps I should use <32> for space to make it clearer:
note that you normally “double up” < to be << except when you are specifying character decimal values.
and also note I am using - as the separator between the two sets of quotes.
note also that sometimes you have to do tricks to get a trailing space to work on quotes due to the way ST clips the quotes - so in this case I put the case with the trailing space FIRST so that it works perfectly.
Hello again Niels
I probably should have added that if you find having multiple quotes specified too confusing or find a situation that cannot be readily handled, you could always fall back to manually removing the quotes using st.trim
st.split(',') ! split on comma
loop x = 1 to st.records()
as they say, many ways to skin a cat.