3 Replies Latest reply on Dec 14, 2012 8:49 AM by LWH777

    Help with script, replacing text with calculated result

    LWH777

      Title

      Help with script, replacing text with calculated result

      Post

           Can anyone help me with writing this script? Here's my scenario: 

           I need a script that will go through each record in a database and if the contents of one particular field in contains a dash followed by a space ("- ") I want to delete the contents of the field starting at the dash, and deleting everything to the right of the dash. 

           I'm not sure if this is even possible. Everything I've tried so far clears the entire contents of the field. 

           Anyone have any ideas that might help?