Regular Expressions 101

Community Patterns

Select formula content without '='

1

Regular Expression
PCRE2 (PHP >=7.3)

/
(?<=\=).+?((?=\t)|(?=\n))
/
gm

Description

RegEX: (?<==).+?((?=\t)|(?=\n)) -- positive Lookbehind szuka znaku '=' na początku -- .+? -- zaznacza: . matches any character (except for line terminators) +? matches the previous token between one and unlimited times, as few times as possible, expanding as needed (lazy) -- positive Lookahead szuka znaku <tabulator: \t> | lub | <new_line: \n>

Submitted by Piotr Osada - 25 days ago