Best Of
Re: Earn a badge and 20 easy points by updating locations in your profile!
Done… but not as fast as Grant and Michelle (unsurprisingly) 😁
Re: Earn a badge and 20 easy points by updating locations in your profile!
DONE… but no Detroit? 😧
Re: How do I take a portion of a column value and push it to a new column?
CASE WHEN REGEXP_LIKE(`field`, '^(A\d+).*$') THEN REGEXP_REPLACE(`field`, '^(A\d+).*$', '$1') ELSE 'unassigned' END
You can use a formula tile and a regular expression to pull out the values which start with A followed by some numbers.
^ - Start of the line
() - Match group to store the results found - in this case the first match group which is stored in the variable $1
A - the literal letter A
\d+ - One or more digits
.* 0 or more of anything
$ - The end of the string








