Parse upper case letters

[Anon1234]

I want to create a column wherein all the uppercase letters will be pulled. Example:

AB-01234 to AB

FGV1234566 to FGV

FYU02022 to FYU

LBA123456 to LBA

GRT5678910 to GRT

[JosephSerpis · Accepted solution]

Hi @Anon1234 you can use regex to parse upper case letter only. Specifically \u will find all upper case characters in a string. I've mocked up a example.

[gawa · Accepted solution]

hi @Anon1234 

Simple Regex can help it. Please refer to the attached WF.

Regex expression "\u" matches all upper case letter, which is equivalent to [A-Z]. 

[Anon1234]

This works! Thank you😊