Seperate a string into Rows / Columns based on a symbol

In my mind this is much like csv style seperation. However it doesn't seem to work quite the same way.

I have a long string of values i need to split out into a table.

I've hand-typed one row from the string as I'd like it formatted. Each Column is delineated by the | symbol.

I tried to use text-to-columns to split it into separate columns, but put everything back to the raw input so you guys can see what the input looks like.

Please advise.

Once again, thank you for your assistance folks!

what I'm looking to get are multiple rows that form up after the FALSE statement in the table. If it helps it's every 5th "|"

I'm currently playing around with the FindWord function from here:
http://www.extendoffice.com/document...-nth-word.html

I changed the formula to look for "|" as a word separator and I can now call =FindWord(A1,Column()) to get "Ark Advance" to populate into A4, and drag that across the table to fill that row.
However, I now need to be able to skip to the next line after the Dino column and start the next row, still pulling from the same cell A1.

So i need some sort of counter to keep it going. Maybe a count() of the "|" characters?

Thank you Richard, that works for the first row of information I'm looking for, how would I keep that going though? I want to continue the information pull down to A5 after E4. When I try to pull the formula you have there it just gives me #VALUE! errors.

I've been able to continue by manually putting a line break after each 5th |, however now my interest is peaked and I am sure to run into this again. I've quite curious how to make it work at this point. Even if it were to delve into VBA I'm looking to get my feet wet there as well.