I’d like a formula to remove the [1][2] instances from the column data
Solved
How to remove [1],[2] from list of data
Best answer by Justin_Barrett
IF({First Nations}, REGEX_EXTRACT({First Nations}, "[^\\[]*"))
The regular expression effectively says: grab everything up to—but not including—the first square brace.
+21IF({First Nations}, REGEX_EXTRACT({First Nations}, "[^\\[]*"))
The regular expression effectively says: grab everything up to—but not including—the first square brace.
IF({First Nations}, REGEX_EXTRACT({First Nations}, "[^\\[]*"))
The regular expression effectively says: grab everything up to—but not including—the first square brace.
Perfect, works great thank you!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.