Regex ISIN ticker

[Lauritsjust]

I am trying to isolate the ISIN ticker using the RegEx tool, but my expression deletes the entire cell.

The cell contains text like this:
:35B:ISIN AB0000123456 20B

I would like the output to be this:

AT0000743059

I have identified the ticker using the expression ([A-Z]{2})([A-Z0-9]{9})([0-9]{1}), but it deletes only the chosen.

Any suggestions?

[atcodedog05 · Accepted solution]

Hi @Lauritsjust 

If your id length is fixed then you can use regex like this

Hope this helps : )

[Lauritsjust]

Thanks!

[atcodedog05]

Happy to help : ) @Lauritsjust 

Cheers and have a nice day!