
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 06:20 AM
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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 08:34 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 08:34 AM
Yep.
REGEX_REPLACE(Tags, "([a-z])([A-Z])", "$1,$2" )

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 08:48 AM
@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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 08:51 AM
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 $

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 08:57 AM
Thank you! (just adding characters to reach 20 characters… ;))
