Finding and counting user udpates in a work log

[dacards]

I'm looking for a way to find work log entries made by unique users and then count the number of entires made. Work log entires are saved as seen below with a time stamp followed by a users login name. The next line then shows the state they are from. The next line(s) would contain that users update.


10/12/2006 8:22:46 AM DaveA
Missouri
Please run test.

10/12/2006 8:23:03 AM JohnB
California
Running test right now.

10/12/2006 8:23:19 AM MikeC
California
Test completed.

10/12/2006 8:23:41 AM JohnB
California
Closing issue as test was completed.

10/12/2006 9:22:46 AM DaveA
Missouri
Issue Resolved.


I want a formula that looks for "California" and then goes to the previous line and grabs the users login name. In this example it would display:

JohnB (2 entries)
MikeC(1 entry)



Thanks again for your help.

 

[lbass]

First create a record selection formula like:

{table.field} like "*California*"

I don't have a way of testing this, but you could then try creating a formula like:

stringvar array x := split(split({table.field},chr(13))[1]," ");
stringvar y := x[ubound(x)];

Insert a group on this formula and then insert a count on the field at the group level.

Note that if this is a memo field, whether you can do this might depend on your version of CR, which you should always identify when posting.

-LB