Count the number of those 'square' type of characters and then dot he math on them. There should be a linear relationship on the number of those characters and the number of entries in the diary field I would think?
That's the best I can think of based off my knowledge of the diary field contents, without really poking into real data to have a look at it. Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Lister Sent: Tuesday, July 09, 2013 9:22 AM To: arslist@ARSLIST.ORG Subject: Re: parsing timestamp in diary field using Crystal or Remedy ** Lj, Thanks again for responding, much appreciate. T On Tue, Jul 9, 2013 at 9:11 AM, Longwing, Lj <llongw...@usgs.gov> wrote: ** Well, unfortunately, what you are dealing with there is the reason that Diary fields have really fallen out of favor. You may be able to come up with a 'regular expression' that can pull that out (I don't know if Crystal supports regular expressions)....sorry, not sure if I can help you much on it. On Tue, Jul 9, 2013 at 7:06 AM, Remedy Lister <remedy.lis...@gmail.com> wrote: ** Lj, Thank you for responding. I am using Crystal with Remedy ODBC driver. What I am trying to do is parsing out each timestamp entry in the diary field without the text content or do a count for each entry in the diary field. I don't what else would be the best common key that I could use to do this except working with the timestamp in the diary field. Thanks in advance T On Tue, Jul 9, 2013 at 8:48 AM, Longwing, Lj <llongw...@usgs.gov> wrote: ** If you are using Crystal with the ODBC Driver, you shouldn't need to parse through the values as it should be translated for you. On Tue, Jul 9, 2013 at 5:31 AM, Remedy Lister <remedy.lis...@gmail.com> wrote: ** Does anyone have formula or workflow that loop through the diary field to parse out the date or timestamp either through Crystal Report or Remedy? Thanks in advance _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
