This calculation performs a culture-sensitive and case-sensitive comparison based on your DAS (or JDE) language setting.
Strip Blanks will remove the blank characters in a column before doing the calculation. For example, the business unit column frequently has leading spaces. If you want those spaces to be maintained in the comparison of values, uncheck the "Strip Blanks" check box.
The result is a new calculated column where the result is:
Result
Meaning
-1
Input 1 precedes Input 2 in a sorted list based on culture rules
0
Input 1 equals Input 2
1
Input 2 precedes Input 1 in a sorted list based on culture rules
Culture Rules include Alphabetic order, uppercase before lower case, numbers before alpha, punctuation before numbers