Extract text from string

[b_urhan]

Hello everybody,

I am trying to specific text from string, as you can see in the attachment there is an address and the code which starts with BM-, I want to get the string which starts BM and the code after that like BM-1146.

I would appreciate if you help me,

Thanks in advance!

[Drussek · Accepted solution]

[ImadZidan]

Hello @b_urhan ,

Regex I think should work.

Have a look and it will at least give you an idea.

Hope you find it helpful.

[ImadZidan]

Hello @b_urhan ,

apologies @Drussek you posted whilst I am posting.

Please @b_urhan  ignore mine as it looks the same as @Drussek

thank you  

[b_urhan]

Thank you!