Regular Expressions 101

Community Patterns

Community Library Entry

0

Regular Expression
PCRE2 (PHP >=7.3)

/
^(?:<?+\$(\d+))?-?(?:>?(\d+)k)?
/
gm

Description

Now that we have Income in a column we can split it up into upper and lower as they are two different values. We can use multiple ways to extract this information, seperate, extract, or case_when. I will be using extract as this provides the best way to collect this information.

Submitted by anonymous - 3 years ago