Parse a worklog entry?

[CRoompa]

I am using CRXI and trying to figure out how skip over the first part of a worklog entry and extract out the next 40-50 characters at the beginning of each work log entry.

The worklog is formatted like this:

Wednesday, 8/20/2008 17:17:52 USERNAME (EMPLOYEE##)
START OF THE ACTUAL WORK LOG TEXT

I just want to extract out: START OF THE ACTUAL WORK LOG TEXT

Appreciate any advice.

 

[lbass]

Try:

mid({table.string},instr({table.string},"#)")+2)

-LB

 

[CRoompa]

I was so close... but didn't have my syntax quite right. Your formula worked great! Thanks.