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.  Finding field 1 data in field 2

    Employee
    Posted 03-24-2010 15:22

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

    Originally posted by: Kelvin

    This is proabaly an easy one but it has me stumped!

    I have 2 fields 1 with a set of data and field 2with a multivalue field delimited with a �. what I want to do is exclude all where the data in 1 does not match a value in field 2. I can't split field 2 as it will affect another field. My thoughts was to use the "Split by Pattern" node and put Field 1 in "Fields" and 'Field 2' in "Pattern". Any ideas?

    eg
    field 1 field 2
    GTCode Fixed
    5391101 539KA04�5391101�999M1EC
    5391101 539KA02�5391101�999M1EC
    5391101 539KA02�5391101�999M1EC
    5391101 539KA02�999M1EC
    5391101 539KA02�5391101�999M1EC
    5391101 5391101�539KA02�999M1EC
    5391101 5391101�539KA02�999M1EC
    5391101 539KA02�999M1EC�5391101
    5391101 539KA02�5391101�999M1EC
    5391101 5391101�539KA02�999M1EC
    5391101 539KA02�5391101�999M1EC
    5391101 539KA02�999M1EC�5391101
    5391101 539KA02�5391101�999M1EC


  • 2.  RE: Finding field 1 data in field 2

    Employee
    Posted 03-24-2010 15:30

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

    Originally posted by: leekennett

    You could use the function strFind.

    where strFind(field2,field1) >= 0