Search results for query: *

Morning LBass I changed the split char for stringvar "y" from 'chr(13)' to 'chr(10)' and its grabbing the last entry on every test ticket ive checked so far. Thank you very much, sir. Exactly what i needed.

For the most part that grabs the last entry. Only if there are some '/' in the entry does it return partial work log entries. Thanks this gets me started down the right track.

The work log is 1 field. The last modified by field is not displayed in my example. The formula above works, but doesnt grab only the last work log entry. New entries are appended at the bottom of the work log field so it grows with each entry.

Below is an example of whats in the work log memo field. Ive got no way to split out the last entry starting at '11/27/2012 7:33:30 AM user2' in the example. last modified by would be the user that made a change to the ticket (e.g. user1, user2). My problem is the change may not update the...

Hello I need to parse through a 'work log' and grab the last entry into the field. The table i am working with does not have a time stamp field for the specific entries. The entries are prefaced by a datetime stamp (dd/mm/yyyy hh:mm:ss am/pm), and a username. If the user is part of any groups...

Perfect! Thank you for working through this with me even though I may have wasted some of your time. This works exactly how I envisioned and will save me a ton of time going forward. Great! Thanks again!

Thank you much for the reply. The formula is not returning anything. In the previous responses to this thread i grabbed example worklog data from our ticketing app, instead of out of the DB. Looks like there is a discrepency in how the date is formatted between the two (Tuesday, January 10...

Reference for the formualas: instr worklog test1 = instr({HIS_MOD_TRB_Trouble.Work_Log},chr(13)) instr worklog test2 = instr({HIS_MOD_TRB_Trouble.Work_Log},chr(10))

Results: instr worklog test1 0.00 instr worklog test2 56.00

*Date/time and username preceed every log entry. Left that out on the above post.

hello lbass, Precisely. The date/time stamp is tagged above the corresponding entry. There are no breaks other than an empty line between entries.

Sorry for not being clear. I would like both the line containing the timestamp and username plus the corresponding entry. Example: Tuesday, January 10, 2012 12:39:15 PM jdoe NOC - IP - Group here it is again xxx % - DeviceIP: xxx 1 1/10/12 12:36:14 PM 1/10/12 12:36:14 PM...

Thank you for working with me on this. I did not have the formula field set to 'can grow' previously. I have set it to 'can grow' for below example. raw worklog field: Tuesday, January 10, 2012 12:25:55 PM nms Process ID: xxx Node: xxxx Summary: Alert: OM Device Interface xxx Receive...

Formula returning the same information. whileprintingrecords; stringvar array x := split({HIS_MOD_TRB_Trouble.Work_Log},chr(10)); stringvar y := ""; numbervar i; numbervar j := ubound(x); for i := 1 to j do( if {?User} in x[i] then y := y + x[i] + chr(10) ); if len(y) > 1 then left(y,len(y)-1)

whileprintingrecords; stringvar array x := split({HIS_MOD_TRB_Trouble.Work_Log},chr(10)); stringvar y; numbervar i; numbervar j := ubound(x); for i := 1 to j do( if {?User} in x[i] then y := y + x[i] + chr(10) ); if len(y) > 1 then left(y,len(y)-1)

Magic! So changing chr(13) to chr(10) is returning an entry in the middle of the worklog for the specified user. It is omitting info if the user enters to many blank lines in an entry. It is also only returning the 1st line of their 2nd entry in the same worklog. Example of what im seeing...

Thank you much for the info. This formula is returning the entire worklog if the specified user is included. I tried tweaking the formula a bit, but still cant get it to return only the specified user's entries. I do have access to an audit table where i am able to count the number of entries...

Yes, the worklog is all one row. I do want to show all entries by a specific user. The usernames are uniform to first intial lastname. So it would show 'jdoe'. Example of what I would like to see. I changed the time stamp for the 2nd entry. They should not have been the same time in the...

I need to pull specific user entries from a 'work log' field. This field is updated anytime a user adds a comment to the designated ticket, and the entry is tagged with the username and a timestamp. The entries are only available through the work log. Below is an example of a typical work...