in reply to How do I combine SPLIT with trimming white space
Then the items returned from split will have neither leading nor trailing whitespace, assuming that your original string doesn't have them.