Hash File and the Timestamp.

lax · Post by **lax** » Thu Nov 18, 2004 1:45 am

Hi All,

I have to change the Timestamp of length 23 to 19 in the Hash file for about a set of 500 Jobs. What could be the best practice to do this. Can we write some query to reduce the time spent to do this work .
Please let me know , if anyone can answer this question.

Thanks in Advance,
lax

him121 · Post by **him121** » Thu Nov 18, 2004 2:39 am

hi..
you can take export of all the 500 jobs..as XML format.
open in to TextPad Editor where u can play with XML.
then use Find/Replace. and change all 23 to 19.

chulett · Post by **chulett** » Thu Nov 18, 2004 8:35 am

a) I'd be very careful if you take that route. You wouldn't want to change every occurance of 23 - only the entries associated with your hash file.

b) Out of curiousity, why do you feel you 'need' to do this? What kind of a problem is this causing?

c) Welcome aboard!

lax · Post by **lax** » Thu Nov 18, 2004 11:53 pm

Hi Chulett

we perform this conversion from 23 to 19(timestamp). This is because we supress the millisec part in the datefield . If not done, the lookup might fail, even though the date and the time of the source is matching with that of the lookup.
Eg: normally we have the datefield as:

2004-11-11- 12:21:32.002. we truncate the last millisec part".002".