9 Replies Latest reply: Oct 14, 2016 8:41 AM by Priyabrata Das RSS

    interval between date and time

    Priyabrata Das

      Hi All,

      I have a requirement like .. I have 2 files with IP, UID and User Time and i need to identify the common User name having same IP, UID and User Time falling with in Initial and Final Time of 2 nd file.

       

      File 1 :

      Ip                         UID          User Time

      142.09.80.30, a00asdtt, [10/Sep/2016:10:34:00 +0800]

       

      File 2:

      IP                              UID     intial time                                   Final Time                                        UserNAme

      122.10.90.104,E00543,   Tue Sep 13 10:44:37 SGT 2016Tue Sep 13 11:44:25 SGT 201         CV001

       

      Message was edited by: Priyabrata Das