regex101: PCRE (Legacy) Match Workspace

Pro

Non-Capturing Group(?:,|^|=[\w.]+\s+)

1st Alternative,

,the literal , (44₁₀ / 54₈ / 2C₁₆)

2nd Alternative^

^start of line

3rd Alternative=[\w.]+\s+

=the literal = (61₁₀ / 75₈ / 3D₁₆)

Character Class[\w.]+

+matches at least one character from the set below:

\wany word character

.the literal . (46₁₀ / 56₈ / 2E₁₆)

\s+any whitespace character, repeated at least once

avgthe literal text avg (case sensitive)

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

shopsthe literal text shops (case sensitive)

\s*any whitespace character, repeated any number of times

=the literal = (61₁₀ / 75₈ / 3D₁₆)

Group 1([0-9.]+)

Character Class[0-9.]+

+matches at least one character from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

.the literal . (46₁₀ / 56₈ / 2E₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

25 tokens

Regular Expression

(?:,|^|=[\w.]+\s+)avg\\ shops\s*=([0-9.]+)

Monday,City=Nice,total\ avg\ shops=350,avg\ shops=20 month=jan
Monday,City=Nice total\ avg\ shops=23 avg\ shops=10 month=Feb
Monday,City=Nice total\,avg\ shops=30 avg\ shops=50 month=Feb
Monday total\,avg\,shops=30 avg\ shops=50,City=Nice month=Feb
Region,Network=myTelco total\ avg\ shops=30.0 avg\ shops=20color=Pink 1590424200000000000

Extraction

Monday,City=Nice,total\ avg\ shops=350,avg\ shops=20 month=jan
Monday,City=Nice total\ avg\ shops=23 avg\ shops=10 month=Feb
Monday,City=Nice total\,avg\ shops=30 avg\ shops=50 month=Feb
Monday total\,avg\,shops=30 avg\ shops=50,City=Nice month=Feb
Region,Network=myTelco total\ avg\ shops=30.0 avg\ shops=20color=Pink 1590424200000000000