15 Replies Latest reply: Oct 24, 2013 8:55 AM by Kerri Theriault RSS

    How to perform exact match on concatenated string

      Hello,

       

      I have a scenario like the following

       

      Table:

      TESTING123

      TESTING

       

      Concatenated String:

      TESTING123|TESTING

       

      When I do a match in table for TESTING, I'm getting 2 items returned.  How can I make it so that my match ensures that the whole string matches and not something like a "contains"?  I can't really use match() because I'm actually looking in a concatenated string.  Also, I'll never know at what position my string exists.  Currently, I'm doing an Index(), but that's returning both strings, not just the 1 that I want.  Hope that makes sense.  Thanks!