4 Replies Latest reply: Jan 4, 2018 11:15 AM by Twan Peters RSS

    Extract pre-defined keywords out of string

    Twan Peters

      I have 2 fields:

      1) Strings

      2) Search field

       

      I want to mark the strings that contain a name that is listed in Search Field.

      The result should be that a third field will be added, with the mark:

      1) Strings

           1.1) String - Search field.

      2) Search field

       

      With this i can easily filter on strings that contain a specific keyword that is stored in 'Search field'.

       

      I'm struggling with this, does someone know how to accomplish this

       

      Example data:

       

      String:

      1) This hotel has a very poor service.

      2) This hotel has a great service.

      3) The festival was awesome

      4) The new birthday campaign is launched

       

      Search fields:

      poor service

      great service

      festival

      birthday campaign

       

      Result

      String: This hotel has a very poor service.

      Search field: poor service

       

      String: This hotel has a great service.

      Search field: [Blank]

       

      String: The festival was awesome

      Search field: festival

       

      String: The new birthday campaign is launched

      Search field: birthday campaign