regex101: expressions

1st Alternativelatest

latestthe literal text latest (case sensitive)

2nd Alternativediff

diffthe literal text diff (case sensitive)

3rd Alternativeavg

avgthe literal text avg (case sensitive)

4th Alternativemedian

medianthe literal text median (case sensitive)

5th Alternativetotal

totalthe literal text total (case sensitive)

6th Alternativerollingmedian

rollingmedianthe literal text rollingmedian (case sensitive)

7th Alternativerollingavg

rollingavgthe literal text rollingavg (case sensitive)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group par(?<par>[^(),]*)

Negated Character Class[^(),]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

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

Group uom(?<uom>[^(),]*)

Negated Character Class[^(),]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

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

Non-Capturing Group(?:,(?<sp>[^()]*|))?

?repeats the group contents below at most once:

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

Group sp(?<sp>[^()]*|)

1st Alternative[^()]*

Negated Character Class[^()]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

2nd Alternative — matches an empty string

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

2nd Alternative((?<func1>diffdays)\((?<par1>[^(),]*)(?:,(?<sp1>[^()]*|))?\))+

Group 6((?<func1>diffdays)\((?<par1>[^(),]*)(?:,(?<sp1>[^()]*|))?\))+

+repeats the group contents below at least once:

Group func1(?<func1>diffdays)

diffdaysthe literal text diffdays (case sensitive)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group par1(?<par1>[^(),]*)

Negated Character Class[^(),]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

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

Non-Capturing Group(?:,(?<sp1>[^()]*|))?

?repeats the group contents below at most once:

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

Group sp1(?<sp1>[^()]*|)

1st Alternative[^()]*

2nd Alternative — matches an empty string

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Global pattern flags

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

Search reference

Regular Expression

((?<func>latest|diff|avg|median|total|rollingmedian|rollingavg)\((?<par>[^(),]*),(?<uom>[^(),]*)(?:,(?<sp>[^()]*|))?\))|((?<func1>diffdays)\((?<par1>[^(),]*)(?:,(?<sp1>[^()]*|))?\))+

New

rollingmedian( ecoli,  orgs/100mL, [tat10, tat11]  ) + latest(ecoli,) + diffdays(ecoli)

Regular Expressions 101

Regular Expression

Extraction