Oct 05, 2022 09:02 PM
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.
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.
Oct 05, 2022 10:00 PM
Perfect, works great thank you!