Re: parsing timestamp in diary field using Crystal or Remedy
One way might be to increment and store the entry count when the note is added by using a display only text field to add the note and set the diary to read-only for note display and have a button to add the note to the diary field and increment the count or set it to the diary on save and increment the count. This wouldn't help on existing records, but would on all new records. Paul Campbell | Development Team Lead | TSD SSBL, A2R WFE, and ESP Remedy Team | Avaya Client Services | | 1145 Sanctuary Parkway Lake View II Suite 110 Alpharetta, GA 30009 | 678-421-5342 From: 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 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.govmailto: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.commailto: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.govmailto: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.commailto: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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
parsing timestamp in diary field using Crystal or Remedy
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
Re: parsing timestamp in diary field using Crystal or Remedy
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 the date or timestamp either through Crystal Report or Remedy? Thanks in advance _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
Re: parsing timestamp in diary field using Crystal or Remedy
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.comwrote: ** 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: parsing timestamp in diary field using Crystal or Remedy
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.comwrote: ** 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.comwrote: ** 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
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.comwrote: ** 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.comwrote: ** 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_ _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
Re: parsing timestamp in diary field using Crystal or Remedy
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