7 Replies Latest reply: Jun 19, 2017 1:21 AM by Kamal Kumar Sanguri RSS

    Loading unstructured text data

    Marc Verhelst

      Purpose is analysing log file of FLEXLM license manager.

       

      Wants to load text file where on some points in file, there is a date. From that point, date must be changed, till I find a new date in file :

       

      fex. :

       

      6:06:27 (lmgrd) TIMESTAMP 6/12/2017

      6:06:27 (ptc_d) OUT: "A" 1@PCDELL11593W7 

      7:00:40 (ptc_d) IN: "A" 2@PCDELL13306  (INACTIVE)

      7:04:16 (ptc_d) OUT: "B" 2@PCDELL13306 

      7:19:27 (ptc_d) OUT: "B" 3@PCDELL13295

      6:06:27 (lmgrd) TIMESTAMP 6/13/2017

      6:06:27 (ptc_d) OUT: "A" 1@PCDELL11593W7 

      7:00:40 (ptc_d) IN: "A" 2@PCDELL13306  (INACTIVE)

      7:04:16 (ptc_d) OUT: "B" 2@PCDELL13306 

      7:19:27 (ptc_d) OUT: "B" 3@PCDELL13295

       

      In my result, I want to see the date find in timestamp added to the time in the following lines. How can this be done during load of text file.

       

      Result should be

       

      6/12/2017 6:06:27 (ptc_d) OUT: "A" 1@PCDELL11593W7 

      6/12/2017 7:00:40 (ptc_d) IN: "A" 2@PCDELL13306  (INACTIVE)

      6/12/2017  7:04:16 (ptc_d) OUT: "B" 2@PCDELL13306 

      6/12/2017 7:19:27 (ptc_d) OUT: "B" 3@PCDELL13295

      7/12/2017 6:06:27 (ptc_d) OUT: "A" 1@PCDELL11593W7 

      7/12/2017 7:00:40 (ptc_d) IN: "A" 2@PCDELL13306  (INACTIVE)

      7/12/2017  7:04:16 (ptc_d) OUT: "B" 2@PCDELL13306 

      7/12/2017 7:19:27 (ptc_d) OUT: "B" 3@PCDELL13295