Stripping out text from a string

[beebass]

Hi there

I currently use Crystal 9. I am designing a report that requires certain parts of a text field to be stripped out. My company classifies its customers with a status. They are either current (receiving service) on hold or finished. For the On Hold and Finished statuses the list to choose from in the database gives the status with an appended reason for example Finished - Change of Service Provider or On Hold - Customer Decision. I need to be able to strip out these reasons so only the reason is showing.

 

[CR85user]

Try:

extractstring({table.field},'- ',' -')

'J

 

[beebass]

Thanks 'J, that worked a treat.