AnsweredAssumed Answered

Plucking segments from a string

Question asked by DLW-BPEX on Nov 13, 2009
Latest reply on Aug 2, 2015 by Shrab


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.