Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Regex to split string into comma-separated tags

Topic Labels: Formulas
Solved
Jump to Solution
465 4
cancel
Showing results for 
Search instead for 
Did you mean: 

My datafile has a field with multiple tags that are joined like this:

TagoneTagtwoTagthree

Is there a formula possible, with help of regex, to put a comma between all lowercaseUppercase instances to seperate them?

1 Solution

Accepted Solutions

Yep.

REGEX_REPLACE(Tags, "([a-z])([A-Z])", "$1,$2" )

See Solution in Thread

4 Replies 4

Yep.

REGEX_REPLACE(Tags, "([a-z])([A-Z])", "$1,$2" )

@Kamille_Parks If you don’t mind, what you point me to a support article in which the use of variables ($1/$2 in your case for the capture groups) is described? I tried to find it just now and couldn’t… Thank you!

its not really documented, just noted that putting parentheses around a portion of a query creates a “numbered capturing group”. from there its extrapolating the relative order of each group you create preceded by a $

Thank you! (just adding characters to reach 20 characters… ;))