How to find two capital letters in a string


#1

Hi experts.

I have some strings such as:

001 Lenovo Flex 5 Laptop, 15.6in.EA 90.0001 I
002 Microsoft,Surface Pro, 12.3"DZ 100.0000 II
003 Apple,iPad mini 4EA 12.3456 III

Is there any way to find Unit of Measure (two capital letters) from the original string and extract like:

EA
DZ
EA

Thank you!

Find two capital letters from string.xaml (9.3 KB)


#2

Pattern = “[A-Z]{2}”
Untick - “Ignore case” option


#3