Submitted by Jon - 7 years ago
How to get various values within a pipe delimited string
We have a pipe delimited text file and each new record is separated by a CRLF. Each record has a fixed number of pipes, but not every column or field is valued, so there may be 2 or more pipes together. Is there a way to write a regex to parse out the third or fifth value? Many thanks in advance.