Hi, I'm trying to separate text with a vb function, but I'm not really sure what to use. Here's an example of the format of the text:
The length of the substrings between the underscores can be of varying length. I would like to have the text up to the first underscore as the first substring, the next as the 2nd, the next as the 3rd. Aside from the split function, are there other options?
Perhaps more specifically what I need is some way to assign the different substrings to variables. I see on the SPLIT function that you can set the delimiter, count, and compare, but getting each distinct substring is a mystery.