Extract or populate Upper case wording in alteryx

[SH_94]

Hi community,

I have long list of data as example below and i want to extract only Upper case letter and it is Assets. But i try to use the formula tool and it does not work. May i know how to extract only specific upper case wording?

Input
ASSETS

Assets
ASSets

Liabilities

Expected output
ASSETS.

Thank you

[Qiu · Accepted solution]

@SH_94 
We can use case sensitive featture in Contains function of formula tool as below.

[WirkKarl]

This is a common challenge! I usually combine REGEX_Match to detect fully uppercase words and then use IF statements to extract them. Curious if anyone has a cleaner formula for large datasets — would love to see alternative approaches!

[binuacs · Accepted solution]

@SH_94 another option with regex

[alexnajm · Accepted solution]

In newer versions of Alteryx you also have the IsUppercase function: https://help.alteryx.com/current/en/designer/functions/test-functions.html#isuppercase