3 Replies Latest reply: Jun 24, 2014 12:19 PM by Jay H RSS

    Drop all characters after string is detected in field



      After a lot of trial, error and searching the forums i cannot seem to come with a conclusion to my issue. If anyone can help that would be greatly appreciated.


      I'm trying to drop all characters (numeric or non-numeric) after a word in a field is detected:


      I want to be able to drop EVERYTHING after "router" is found in the field resource and keep everything before it




      field name:

      • resource

      field values:

      • CA-E-router123.cisco
      • AP-V-router2.cisco
      • ME-UL-router72.cisco

      desired result:

      • CA-E-router
      • AP-V-router
      • ME-UL-router


      Thanks in advance!