Table of Contents

Compare Strings

Description

Allows two columns to be compared as strings by returning a value of -1, 1, or 0 based on the outcome of the comparison.

Calculation Editor

Options

Input Parameter Values Input Values
Strip Blanks Check Box
Only Rollup If Generic Criteria

Input

Input Input Values Required
Input 1 Column or Literal ✔
Input 2 Column or Literal ✔

Remarks

  • 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

Examples

Example 1 (Mismatched Text)

  1. Inputs: Clothing Incorporated & Clothing Inc.
  2. Quick Calculations > Text > Compare Strings
  3. Output: 1

Example 2 (Mismatched Integers)

  1. Inputs: 17 & 24
  2. Quick Calculations > Text > Compare Strings
  3. Output: -1

Example 3 (Matched Text)

  1. Inputs: Bikers R Us & Bikers R Us
  2. Quick Calculations > Text > Compare Strings
  3. Output: 0