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

    Drop all characters after string is detected in field

      Hi,

       

      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

       

      eg.

       

      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!