DAX to FIND or SEARCH uppercase string with certain length

[Anonymous]

Is it possible to use FIND or SEARCH function to look for upper case string in a column with specific length?

[jrmaier]

Hello,

Trying to clean up a constituent database by finding all instances of where someone used all caps in a field similar to the example below. The table has 19k+ rows.

Prefix	FirstName	LastName	Suffix	GradYear	HomeAddress1	HomeAddress2	HomeCity	HomeState	HomeZip
Mr.	James	MAIER			12345 MYSTREET		HOMETOWN	MI	12345-1234

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Based on test, I found that 'FIND' function support uppercase filter, 'SEARCH' function not support.

UPPER/LOWER(FIND) = FIND("BET",[Text])&"/"&FIND("bet",[Text])

UPPER/LOWER(Search) = SEARCH("BET",[Text])&"/"&SEARCH("bet",[Text])

Regards,

Xiaoxin Sheng