Shawn, One method is to create a function in your database, and then call the function as needed. The function would need to:
1. Find the keyword. 2. Move back up the text until you find the timestamp and username and parse. 3. Format the timestamp. 4. Return the values. Another approach, albeit more involved would be to replace the diary field with a separate form that holds all diary entries, one record per entry. Then you wouldn't have to parse the diary field. Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Thursday, October 12, 2006 10:27 AM To: [email protected] Subject: Crystal Reports Question - Parsing a Diary Field Greetings List! This question is about Crystal Reports 11. I'm trying to create a which, among other things, finds a key phrase in a diary field, then returns the date/time/user stamp of the entry that contains the key phrase. Does anyone have any idea how this can be accomplished? Thx in advance!!! Shawn Stonequist EMNS, Inc. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
