3 Replies Latest reply: Jun 19, 2013 1:34 AM by Vishwaranjan Kumar RSS

    Finding a match between subfields of two strings

      Is there an expression that can find matches between substrings of two fields that both have comma delimitted substrings?


      Field_1 = 'USA', 'Italy', 'Japan'

      Field_2 = 'Jamaica', 'Italy', 'Australia', 'Korea', 'China', 'Chile', 'Mexico'


      Is there an expression I can use in a text object or a chart, to tell that Field1 and Field 2 do have a match  WITHOUT using the load script?


      In the example above, both fields have 'Italy'. The expression would help to determine that both Field_1 and Field_2 contain 'Italy'.