LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  X-Ref Node and Alphanumeric data

    Employee
    Posted 01-08-2014 09:45

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mw9286

    How do I do the match when there a inconsistency of uppercase and lowercase characters? I want to ignore if uppercase or lowercase and match the example below.

    Table 1, Field 1:
    0440e641

    Table 2, Field 1
    0440E641


    Thank you


  • 2.  RE: X-Ref Node and Alphanumeric data

    Employee
    Posted 01-08-2014 10:00

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    You can put (complicated) expressions into the match.

    LeftInputKey: Field1.toUpper()
    RightInputKey: Field1.toUpper()


  • 3.  RE: X-Ref Node and Alphanumeric data

    Employee
    Posted 01-08-2014 10:11

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mw9286

    That fixed the problem. Thank you