08/11/2011 11:05 GMT Standard Time - AndrewLeates (Original Description) Migrate CreditSolve to new server equipment

 

I created a formula to remove the parts I do not want on my report:

 

mid({TASKS.DESCRIPT},InStr({TASKS.DESCRIPT},") ")+2)

 

Which returns just:

 

Migrate CreditSolve to new server equipment

 

Works very nicely I thought. Until I added another case note in my database, which is appended to the TASKS.DESCRIPT field, so now the date, time and my name are only removed from the start of the string.

 

Is there a way to search for and remove ANY instance of "08/11/2011 11:05 GMT Standard Time -" from the string - obviously the date and times will change.

 

Any pointers appreciated!

 

Andy