Last Entry In Worklog

[Cardstang]

Hello all,

I'm using CR12 and pulling from a Remedy database using an OBDC connection.

I'm looking for a way to extract the last entry in a worklog. Here is an example of the worklog:

Monday, September 05, 2011 10:11:19 AM usnername
Report assigned.

Tuesday, September 06, 2011 4:36:12 PM usnername
Report ready for distribution with a few minor tweaks.

Thursday, September 08, 2011 2:04:22 PM usnername
All tweaks complete. Scheduled to run on Mondays.

What I need is everything from "Thursday" to the end.

The most recent entry will always be at the bottom, and there may be times where there is only one entry.

Any assistance is greatly appreciated.

 

[lbass]

Try:

stringvar array x := split({table.worklog},chr(13)+chr(13));
x[ubound(x)]

This assumes that the "sections" within the field are created by two returns.

-LB

 

[Cardstang]

It doesn't seem to be two carriage returns to create the sections. The formula grabbed everything in the worklog.

I did get it to grab the last entry by modifying to this:

stringvar array x := split({table.Work Log},{table.Last Modified By});
x[ubound(x)]

Thanks for the help!

 

[Cardstang]

Oh and the date/time and usernames are a field. I'm pulling those seperately now and will combine if needed.