Evaluate is String UpperCase

Hi -
Normally we see instances where we convert data to all upper or all lower or proper case. In my current scenario our main record is ALL CAPS and the bad records are mixed cases.

Scenario I’m trying to evaluate against is is the string all caps Y or N.

Unsure if that is possible. If it is not it may be an interesting feature

It should be possible as below:

IF [Data] = upper([Data]) THEN "Y" ELSE "N"

@dgudkov : I should know better sorry!

One more option: use keepchars():

[Data] = keepchars([Data], " ABCDEFGHIJKLMNOPQRSTUVWXYZ")   //added space as well