Re: parsing timestamp in diary field using Crystal or Remedy

2013-07-10 Thread Campbell, Paul (Paul)
: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Tuesday, July 09, 2013 9:03 PM To: arslist@ARSLIST.ORG Subject: Re: parsing timestamp in diary field using Crystal or Remedy ** Count the number of those 'square' type of characters

parsing timestamp in diary field using Crystal or Remedy

2013-07-09 Thread Remedy Lister
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

Re: parsing timestamp in diary field using Crystal or Remedy

2013-07-09 Thread Longwing, Lj
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.comwrote: ** Does anyone have formula or workflow that loop through the diary field to parse out

Re: parsing timestamp in diary field using Crystal or Remedy

2013-07-09 Thread Remedy Lister
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

Re: parsing timestamp in diary field using Crystal or Remedy

2013-07-09 Thread Longwing, Lj
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

Re: parsing timestamp in diary field using Crystal or Remedy

2013-07-09 Thread Remedy Lister
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

Re: parsing timestamp in diary field using Crystal or Remedy

2013-07-09 Thread Joe D'Souza
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