topic Re: Time format conversion and manipulation in Application Development and Automation Discussions

Time format conversion and manipulation

Former Member — Mon, 21 May 2007 04:49:05 GMT

Hi!

I've the following time format in a flat file. 00:03:21,945

HH:MM:SS,TTT, where T = second / 1000

I would like to manipulate this format, by adding some seconds to it (for example add 39 seconds) then write it back to the file in the given format.

What do you think what is the best solution for this?

Please don't answer quickly with 2 words, I'll give points for the best solutions.

Regards

Tamá

Former Member — Mon, 21 May 2007 04:53:41 GMT

this is u r format HH:MM:SS,TTT..

take this into one variable...let var

take last three char into one variable var2.

var2 = var19(3).

now add 39 seconds to this var2..

and move this var2 in to var19(3)...

reward points...

if help full

Former Member — Mon, 21 May 2007 07:10:05 GMT

Hi,

you need to check for the seconds if the time is like this 11:59:30 + 39 sec addition, then you have to use a Fm

split the file time at , into one variable then call the FM

WLF_RRLE_ADD_TIME or

DIMP_ADD_TIME

then pass the values to add

IV_STARTTIME 11:59:20

IV_STARTDATE

IV_STARTTIME 11:59:20

output

EV_ENDTIME 11:59:59

EV_ENDDATE

again concatanete the same separating the by ,

hope this helps

regards

Shiva