Regular Expressions 101

Aggregatethe literal text Aggregate (case sensitive)

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

.*any character (except for line terminators), repeated any number of times

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

Positive Lookahead(?=,)

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

Global pattern flags

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

Aggregate\(.*\)(?=,)

New

Substr(Aggregate(SubQuery, SUM, [Model].Remark * [Object].Shortname + 10), 0, 1)
Substr(Aggregate(SubQuery, SUM, [Model].Remark * ([Object].Shortname + 10)), 0, 1)
Substr(Aggregate(SubQuery, SUM, ([Model].Remark) * ([Object].Shortname + 10) ), 0, 1)

Regular Expression

Substitution