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 >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"