regex101: Excel ABS, SUM, AVG

Non-Capturing Group(?:(SUM|AGV|ABS)$\{((?:[A-Za-z])+)\}$|(?:(SUM|AGV|ABS)$\{((?:[A-Za-z])+)\}\,\{((?:[A-Za-z])+)\}$)|\{((?:[A-Za-z])+)\})

1st Alternative(SUM|AGV|ABS)$\{((?:[A-Za-z])+)\}$

Group 1(SUM|AGV|ABS)

1st AlternativeSUM

SUMthe literal text SUM (case sensitive)

2nd AlternativeAGV

AGVthe literal text AGV (case sensitive)

3rd AlternativeABS

ABSthe literal text ABS (case sensitive)

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

\{the literal { (123₁₀ / 173₈ / 7B₁₆)

Group 2((?:[A-Za-z])+)

Non-Capturing Group(?:[A-Za-z])+

+repeats the group contents below at least once:

Character Class[A-Za-z]

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

\}the literal } (125₁₀ / 175₈ / 7D₁₆)

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

2nd Alternative(?:(SUM|AGV|ABS)$\{((?:[A-Za-z])+)\}\,\{((?:[A-Za-z])+)\}$)

Non-Capturing Group(?:(SUM|AGV|ABS)$\{((?:[A-Za-z])+)\}\,\{((?:[A-Za-z])+)\}$)

Group 3(SUM|AGV|ABS)

1st AlternativeSUM

SUMthe literal text SUM (case sensitive)

2nd AlternativeAGV

AGVthe literal text AGV (case sensitive)

3rd AlternativeABS

ABSthe literal text ABS (case sensitive)

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

\{the literal { (123₁₀ / 173₈ / 7B₁₆)

Group 4((?:[A-Za-z])+)

Non-Capturing Group(?:[A-Za-z])+

+repeats the group contents below at least once:

Character Class[A-Za-z]

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

\}the literal } (125₁₀ / 175₈ / 7D₁₆)

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

\{the literal { (123₁₀ / 173₈ / 7B₁₆)

Group 5((?:[A-Za-z])+)

Non-Capturing Group(?:[A-Za-z])+

+repeats the group contents below at least once:

Character Class[A-Za-z]

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

\}the literal } (125₁₀ / 175₈ / 7D₁₆)

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

3rd Alternative\{((?:[A-Za-z])+)\}

\{the literal { (123₁₀ / 173₈ / 7B₁₆)

Group 6((?:[A-Za-z])+)

Non-Capturing Group(?:[A-Za-z])+

+repeats the group contents below at least once:

Character Class[A-Za-z]

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

\}the literal } (125₁₀ / 175₈ / 7D₁₆)

Non-Capturing Group(?:(\+|\-|\*|\/)(?:(?:(SUM|AGV|ABS)$\{((?:[A-Za-z])+)\}$)|(?:(SUM|AGV|ABS)$\{((?:[A-Za-z])+)\}\,\{((?:[A-Za-z])+)\}$)|(?:\{((?:[A-Za-z])+)\})))*

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

Search reference

Regular Expression

(?:(SUM|AGV|ABS)\(\{((?:[A-Za-z])+)\}\)|(?:(SUM|AGV|ABS)\(\{((?:[A-Za-z])+)\}\,\{((?:[A-Za-z])+)\}\))|\{((?:[A-Za-z])+)\})(?:(\+|\-|\*|\/)(?:(?:(SUM|AGV|ABS)\(\{((?:[A-Za-z])+)\}\))|(?:(SUM|AGV|ABS)\(\{((?:[A-Za-z])+)\}\,\{((?:[A-Za-z])+)\}\))|(?:\{((?:[A-Za-z])+)\})))*

Unit Tests

There are no unit tests, click to add some.