Split String with brackets and corner brackets

Hello boys and girls,

Simple question,

I used Get text to split string
example

Michael Jordan (0022233546)[C]

First Argument must be Michael Jordan
Second one 0022233546
and third must be C

Can anyone help?

Thanks

@Gagi77 Are all the other data in the same Format ? If So, You can use :
Split(yourString,"(")(0).ToString.Trim to get Michael Jordan
Split(Split(yourString,"(")(1),")")(0).ToString.Trim to get 0022233546
Split(yourString,"[")(1).ToString.Replace("]","").Trim

1 Like

It works buddy, thank you

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.