Regular Expressions 101

Community Patterns

Extract Text Between Specific Pipe Delimited Columns

1

Regular Expression
ECMAScript (JavaScript)

/
(?:([^\|]+)\|){3}
/

Description

This RegExp extract text between pipe delimited columns specified by the field index you wish to extract.

Exmaple: |test1|test2|test3|test4| (?:([^|]+)|){1} extracts "text1" (?:([^|]+)|){2} extracts "text2" etc...

Submitted by Samuel Davison - 8 years ago