Help

How to remove [1],[2] from list of data

Topic Labels: Formulas
Solved
Jump to Solution
1111 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Viet_Nguyen
4 - Data Explorer
4 - Data Explorer

Screen Shot 2022-10-06 at 12.00.58 pm

I’d like a formula to remove the [1][2] instances from the column data

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto
IF({First Nations}, REGEX_EXTRACT({First Nations}, "[^\\[]*"))

Screen Shot 2022-10-05 at 9.44.07 PM

The regular expression effectively says: grab everything up to—but not including—the first square brace.

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto
IF({First Nations}, REGEX_EXTRACT({First Nations}, "[^\\[]*"))

Screen Shot 2022-10-05 at 9.44.07 PM

The regular expression effectively says: grab everything up to—but not including—the first square brace.

Perfect, works great thank you!