
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 05, 2022 09:02 PM
1 Solution
Accepted Solutions

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 05, 2022 09:45 PM
IF({First Nations}, REGEX_EXTRACT({First Nations}, "[^\\[]*"))
The regular expression effectively says: grab everything up to—but not including—the first square brace.
Reply
2 Replies 2

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 05, 2022 09:45 PM
IF({First Nations}, REGEX_EXTRACT({First Nations}, "[^\\[]*"))
The regular expression effectively says: grab everything up to—but not including—the first square brace.
Reply

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 05, 2022 10:00 PM
Perfect, works great thank you!
