AnsweredAssumed Answered

Removing a set number of characters from a text string

Question asked by BCSG on Aug 18, 2011
Latest reply on Aug 18, 2011 by 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

Outcomes