2 Replies Latest reply on Aug 18, 2011 4:40 AM by BCSG

    Removing a set number of characters from a text string

    BCSG

      Title

      Removing a set number of characters from a text string

      Post

      I need to remove the last 15 characters from a few thousand records.  What's the best way to achieve this?  

       

      Example:  

      WHOLESALE 125 Watt 12 Volt SOLAR PANEL LOT - 8 x 125W (#130461406134)

      I want to delete (#130461406134), from the string, leaving 

      WHOLESALE 125 Watt 12 Volt SOLAR PANEL LOT - 8 x 125W 

       

      Appreciate any suggestions here! Bill