Dan, take a look at this post splitting a string by a couple different delimiters as well. Both Kem and Tim contributed working solutions. Tim’s perhaps the more approachable in your context of not having to troubleshoot regex. Both effective.
Kind regards, Andrew