can I program a case question?

[borsker]

I am trying to automate some data into another program, however before I do that I need to find out if one of the fields is in all upper case or mixed. Is there any way I can find out without looking at the data first.

 

[rob444]

Test it this way:

? field = upper(field) && all uppercase
? field = lower(field) && all lowercase
? field = proper(field) && proper casing

Or create logical variables to store the testresults for testing in your program like this:

private lIsUpper, lIsLower, lIsProper

lIsUpper = (field = upper(field))
lIsLower = (field = lower(field))
lIsProper= (field = proper(field))

You then can test whatever you want.
Substitute the correct fieldname for field.

Rob.

 

[Germancho]

Try:

IF YourField == UPPER(YourField)
&& All Uppercase
ELSE
&& Mixed
ENDIF

Best regards

Germán Restrepo
Bogotá, Colombia