I have a set of data that I need to qualify based on the text of a field and it is case sensitive. The current load script is pulling ANYTHING that starts with clinical and I need it to recognize CLINICAL all in caps only.
If(Title LIKE 'CLINICAL*' and Metric = 'Letters', 'Include', 'Exclude') as Status
(ooxml, embedded labels, table is Sheet1);
How can I get it to be case sensitive? Any help is greatly appreciated.