Plucking segments from a string
There must be a text function (or combination) to achieve this result:
What is a good way to parse a string like ABCDE|FGH|IjklmnO|...
so that for one field I can capture all characters up to but excluding the first | ("pipe") character? Next field, only everything between the first and second pipes. Third field, only what is between the second and third pipes, etc. Entire text string can vary in length, as can each desired subset.
Thank you, as always.