Regular Expressions 101

Community Patterns

Extract variable data from multi-line text columns

1

Regular Expression
PCRE (PHP <7.3)

/
^Soldto:(?:.*\R){2}\K((?:(?!\s{2}).)+)\K\s*\K((?:(?!\s{2}).)+)
/
m

Description

Pulls data from the 3rd line of different columns of text.

Submitted by Jan from StackOverflow, and John Kimball - 8 years ago