Splitting string into columns on pipe delimiter

[waubain]

I need to split each rows of a string that delimited by pipe (|) characters into columns. Each string can have up to 30-40 delimiters.

I found this example Link that does exactly what I need except mine is delimited by a pipe and not a period.

I can follow some of it, but most of it is beyond my current knowledge base. I can see where it counts the max number of dots to create the correct number of columns, but I do not see what to change to split on the pipe rather than a period. I have seen other examples where it declares the type of delimiter to make more universal, but this example does not provide that flexibility.

Any help would be appreciated.

You don't know what you don't know...

 

[waubain]

I found out more about PARSENAME. It only delimits on a dot(.) and then only up to 4 delimiters. I have over 40 pipes in some strings.

Back to the drawing board.

You don't know what you don't know...