1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

VB Script needed: converting logs columns to rows

Discussion in 'JavaScript and AJAX' started by fono, May 5, 2009.

  1. fono

    fono New Member

    Joined:
    May 5, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi all, i have a bunch of log files that needs to be imported into a database for analysis but the logs comes in the following format:

    ****************************CDR 1****************************
    CDR_TYPE: CallRec
    callingNumber: 7590405
    calledNumber: 7500820
    answerTime: 00:03:39
    releaseTime:00:07:34
    callDuration: 235
    *************************************************************

    ****************************CDR 2****************************
    CDR_TYPE: MOSMSRecord
    serviceCentre: (91)685750004
    recordingEntity: (91)685750007
    location: (LAC: 00 0A CELLID: 75 49)
    messageReference: 31
    originationTime: 2007-09-01 00:07:34 - 0B00
    destinationNumber: (91)6857513394
    *************************************************************

    ****************************CDR 3****************************
    CDR_TYPE: CallRec
    callingNumber: 7583021
    calledNumber: 7552525
    answerTime: 00:04:39
    releaseTime: 00:07:37
    callDuration: 178
    *************************************************************

    I need a script to output data in rows insted of columns filtering only data of CDR_TYPE: CallRec
    Bottom line is, you just need to see if the call is of type "CallRec" & print out every line after the first ':' until you see a bunch of '*', then start over


    The output should be :

    CDR_TYPE callingNumber calledNumber answerTime releaseTime callDuration
    CallRec 7590405 7500820 00:03:39 00:07:34 235
    CallRec 7583021 7552525 00:04:39 00:07:37 178
    ......


    Thanks in advance
    fono
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    Moved to VBScript forum
     

Share This Page