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

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

Parse Brackets.yxmd