HOW TO EXTRACT UPPERCASE CHARACTERS FROM A COLUMN USING A CUSTOM COLUMN IN POWER QUERY EDITOR

[PieroPinzone]

Hi guys, as shown in the picture, I have a column containing regions, states etc all togheter and I'd like to extract regions (that are uppercase, like AFRICA) using a custom column in power query editor (second picture). Can anyone tell me wich is the right pattern? (like "A"..."Z" in the second picture)

[latimeria · Accepted solution]

hi @PieroPinzone ,

Try this

= Table.AddColumn(Source, "Custom", each if [Country] = Text.Upper([Country]) then [Country] else "")