Only want to keep Uppercase Letters - Remove all blanks

InêsMaximiano — Mon, 28 Oct 2024 09:55:20 GMT

I have a character column, which can be either null or have an all Upercase Word.

The problem is when I go to select Column <> "", it selects some lines that in my eyes are null.

I already tried the compress, strip and trim functions, but it did not work.

Can you please help?

data test;

string 1 = "ABCDEF";

string 2 = ""

string 3 = " "

Re: Only want to keep Uppercase Letters - Remove all blanks

Patrick — Mon, 28 Oct 2024 10:32:54 GMT

Answer provided here.