nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Regex solution to extract data from multiple brackets inside a cell

Shahas

Hello,

I have a situation where in the data have to be extracted from inside a square bracket []. The column doesn't have any pattern. These are some of the values in the column :

abc [xyz-123] nsk

[ahd-246]

uteh[iwyt-798]

[kudgb-3645] jvsux [oikjh-35945] ahfvd [kdytd-2384]

As from the examples above, it doesn't follow any pattern. I just need to extract all the data inside the bracket.

I tried using the expression ".*\[(.*)\].*" (excluding ")

It works for most cases but if the cell contains more than 1 bracket pair, it only picks up one data.

Looking for a solution where in i can extract every data inside any number of square bracket.

Thanks in advance

Regex

Accepted answers

BS_THE_ANALYST

@Shahas as @apathetichell mentions, Tokenize can be great here! I've added a couple of extra steps in so you don't have to manually click on how many columns to split by.

RegEx: \[.*?\]

regex_tokenize_groups.yxmd

flying008

Hi, @Shahas

Maybe this way as you want:

录制_2023_02_18_10_27_48_276.gif

1- Formula: Copy the field [Text] to [Parse].
2- RegEx: Remove all characters not in [ ] by regular expression.

(?<=\[)([\w-]+?)\]

3- Text To Columns: Split [Parse] to Columns by "]" .
4- Data Cleansing: Remove all null columns.

******

If it can help you , please mark it as a solution and give a like for more share.

All comments

apathetichell

try the regex tool in tokenize mode.

BS_THE_ANALYST

@Shahas as @apathetichell mentions, Tokenize can be great here! I've added a couple of extra steps in so you don't have to manually click on how many columns to split by.

RegEx: \[.*?\]

regex_tokenize_groups.yxmd

flying008

Hi, @Shahas

Maybe this way as you want:

录制_2023_02_18_10_27_48_276.gif

1- Formula: Copy the field [Text] to [Parse].
2- RegEx: Remove all characters not in [ ] by regular expression.

(?<=\[)([\w-]+?)\]

3- Text To Columns: Split [Parse] to Columns by "]" .
4- Data Cleansing: Remove all null columns.

******

If it can help you , please mark it as a solution and give a like for more share.

Shahas

heyy @flying008

The regex which u used provided me with the solution that i was looking for. Thanks

Shahas

Heyy @BS_THE_ANALYST

This also works. Thanks for your time

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703