Help with script, replacing text with calculated result
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?