2 Replies Latest reply: Oct 3, 2014 7:03 PM by Marco Wedel RSS

    Looping and transforming records

    Ian Jones

      Hi,

       

      I have a brain freeze at the moment and need some help.

       

      I have log files that need transforming

       

      Currently they are as follows

      dID               EventOpen                         EventClosed                         Duration

      100     2014-01-31 17:23:40               2014-02-11 11:23:53               258:00:13

       

      and I need formating

       

      dID                  EvtDate                         Duration

      100         2014-01-31 17:23:40               06:36:20

      100      2014-02-01 00:00:00                   24:00:00

      100     2014-02-02 00:00:00                    24:00:00

      and so on untill

      100     2014-02-11 11:23:53                    11:23:53.

       

      I know its case of looping through I just can't get my head around it at the mo.