Extract text from string

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!

Capture.JPG

Preparation

Accepted answers

Drussek

All comments

Drussek

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.

BMregex.yxmd

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!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335