2 Replies Latest reply: Aug 28, 2017 12:02 PM by Ibrahim Aslan RSS

    Search string with field content

    Ibrahim Aslan

      Hi Friends,

       

      I need your help. How can I make a search in a string with field content from another table, for example a helping csv.

       

      For example:

      Table1:

      Description
      ABCD
      EFGH
      IKL
      XYZ

       

       

      in the csv file will be the string to search and the result to show:

      Table2:

      StringData
      BCResult1
      GHResult2
      KResult3
      XY

      Result4

       

       

      Now I need something like this:

      if(substringcount(Description,String)>0,Data)

       

      The result should be so:

      DescriptionData
      ABCDResult1
      EFGHResult2
      IKLResult3
      XYZResult4

       

      Thank you very much

       

      Best Regards,

      Ibrahim