How to extract just numbers between square brackets in string

[acaryasin01]

Hi Guys,

I hope you all are doing well.

I have a data like below.

I want to extract just number between square brackets in string like Desired Column.

Desired column could be created more than one column. I mean desired column/s could include only one number (extracted from the string) 

Any help would be appreciate. 

My data	Desired column
[1] KCC [333]abc	1, 333
[22] www[444] abc	22, 444
[333] KCw[555][666]	333, 555, 666
[29125  Account
[555]absdhegaf[999]	555, 999
[11][222][333]	11, 222, 333
abc[11]aaa	11
29125] BVVV

Best regards...

[Ben_H · Accepted solution]

Hi @acaryasin01,

There are various ways to do this but here's one example.

I used regex to tokenise the data on numbers in brackets.

Then I just concatenated it into a single field and removed the brackets with a bit more Regex.

Regards,

Ben

[atcodedog05]

Hi @acaryasin01 

My take on this. Similar but slightly different.

Workflow:

Hope this helps : )

[binu_acs]

@acaryasin01 

[acaryasin01]

Thank you @Ben_H it works great 👍🙏😊

Sorry for the late reply.

Best regards...

[acaryasin01]

Hi @atcodedog05 Thank you as well, appreciate

It's working but my data is a bit large and more than 30 column (I would mention but forgot, sorry)

so I need to add Record Id column.

[acaryasin01]

Thank you @binu_acs for your effort and time 👍😊

[atcodedog05]

Hi @acaryasin01 

Groupby on record id too in summarize tool it should work. 

Anyways Happy to help : )

Cheers and have a nice day!