Community Patterns

Community Library Entry

0

Regular Expression
Created·2021-10-24 21:09
Flavor·PCRE2 (PHP)

/
^(?:<?+\$(\d+))?-?(?:>?(\d+)k)?
/
gm
Open regex in editor

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