Regular Expressions 101

Community Patterns

Variable Variance Formula

0

Regular Expression
PCRE2 (PHP >=7.3)

/
(.+\[)(Current Period Result)(\].+\[)(Random field 2)(\].+\/.+\[)(Random field 2)(\].+>\s)(\d+)
/
gm

Description

Variable Variance Formula

This is parsing an Alteryx variance formula to show the versatility of re-writing expressions on the fly in your programs for dynamic repeatability, i.e. field names don't matter, and you never have to re-write the same variance formula again!

Submitted by Chris Kusek - 3 years ago