[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
9.4

How to process this sample text file and load into database?

Asked by tms_92 in Oracle Database

Tags: file, sample

Sample log file name is sample.txt,stored in say "c:\test" folder.The contents of sample.txt is as follows:

>view tob tod peri=1dy fn=a1201020000 grp=ral

   12/02/02_01:08:01 worli sigma146
### view tob start ###


##route analysis traffic observation data##

##status=nom##

#ral=rut_mf2b-rut_htub#
  atpt        rec-comp    ans-comp    bsy-sub     rg-aban     rg-to      
  0000000904  0000000904  0000000510  0000000254  0000000070  0000000007
  pd-aban     pd-to       cng-itra    bsy-ckt     cng-itr1    cng-itr2    
  0000000000  0000000000  0000000001  0000000000  0000000000  0000000000
  err-rec     err-snd     rec-to      snd-to      err-trns    err-rut    
  0000000000  0000000000  0000000000  0000000000  0000000000  0000000000
  rst-sub     rst-rut     acmto       bsig-nrc    vcno        vcno1000    
  0000000010  0000000000  0000000000  0000000000  0000000000  0000000000
  n-trmv      n-disc      n-uasn      n-chgd      other       usg-ans    
  0000000000  0000000000  0000000042  0000000000  0000000010  00003.65  
  usg-comp    usg-icmp    usg-ovall  
  00003.70    00000.03    00003.72  

#ral=rut_mp4b-rut_htub#
  atpt        rec-comp    ans-comp    bsy-sub     rg-aban     rg-to      
  0000000409  0000000409  0000000207  0000000067  0000000069  0000000013
  pd-aban     pd-to       cng-itra    bsy-ckt     cng-itr1    cng-itr2    
  0000000000  0000000000  0000000000  0000000000  0000000000  0000000000
  err-rec     err-snd     rec-to      snd-to      err-trns    err-rut    
  0000000000  0000000000  0000000000  0000000000  0000000000  0000000000
  rst-sub     rst-rut     acmto       bsig-nrc    vcno        vcno1000    
  0000000005  0000000000  0000000000  0000000000  0000000000  0000000000
  n-trmv      n-disc      n-uasn      n-chgd      other       usg-ans    
  0000000000  0000000000  0000000017  0000000000  0000000031  00002.14  
  usg-comp    usg-icmp    usg-ovall  
  00002.16    00000.04    00002.20  

12/02/02_01:08:08 worli sigma146
...view tob end
>view tob tod peri=1hr fn=a1201021100 grp=ral

   12/02/02_01:08:31 worli sigma146
### view tob start ###


##route analysis traffic observation data##

##status=nom##

#ral=rut_mf2b-rut_htub#
  atpt        rec-comp    ans-comp    bsy-sub     rg-aban     rg-to      
  0000000081  0000000081  0000000052  0000000018  0000000008  0000000000
  pd-aban     pd-to       cng-itra    bsy-ckt     cng-itr1    cng-itr2    
  0000000000  0000000000  0000000000  0000000000  0000000000  0000000000
  err-rec     err-snd     rec-to      snd-to      err-trns    err-rut    
  0000000000  0000000000  0000000000  0000000000  0000000000  0000000000
  rst-sub     rst-rut     acmto       bsig-nrc    vcno        vcno1000    
  0000000000  0000000000  0000000000  0000000000  0000000000  0000000000
  n-trmv      n-disc      n-uasn      n-chgd      other       usg-ans    
  0000000000  0000000000  0000000003  0000000000  0000000000  00005.86  
  usg-comp    usg-icmp    usg-ovall  
  00005.99    00000.06    00006.05  

#ral=rut_mp4b-rut_htub#
  atpt        rec-comp    ans-comp    bsy-sub     rg-aban     rg-to      
  0000000032  0000000032  0000000018  0000000005  0000000005  0000000002
  pd-aban     pd-to       cng-itra    bsy-ckt     cng-itr1    cng-itr2    
  0000000000  0000000000  0000000000  0000000000  0000000000  0000000000
  err-rec     err-snd     rec-to      snd-to      err-trns    err-rut    
  0000000000  0000000000  0000000000  0000000000  0000000000  0000000000
  rst-sub     rst-rut     acmto       bsig-nrc    vcno        vcno1000    
  0000000000  0000000000  0000000000  0000000000  0000000000  0000000000
  n-trmv      n-disc      n-uasn      n-chgd      other       usg-ans    
  0000000000  0000000000  0000000002  0000000000  0000000000  00002.39  
  usg-comp    usg-icmp    usg-ovall  
  00002.45    00000.08    00002.52  

 12/02/02_01:08:40 worli sigma146
...view tob end

The column names should be as follows:
raldtdate
raltime
atpt
rec_comp
ans_comp
bsy_sub
rg_aban
rg_to
pd_aban
pd_to
cng_itra
bsy_ckt
cng_itr1
cng_itr2
err_rec
err_snd
rec_to
snd_to
err_trns
err_rut
rst_sub
rst_rut
n_trmv
n_disc
usg_comp
usg_icmp
n_uasn
n_chgd
other
usg_ans
usg_ovall

Now how do I process this file an load the value corresponding to each column denoted by the value below the corresponding name in sample file.Please help with code to process the sample file.
[+][-]04/16/03 01:10 AM, ID: 8339376Accepted Solution

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

About this solution

Zone: Oracle Database
Tags: file, sample
Sign Up Now!
Solution Provided By: schwertner
Participating Experts: 2
Solution Grade: A
 
[+][-]04/16/03 05:16 AM, ID: 8340354Assisted Solution

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 30-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]08/30/04 09:06 AM, ID: 11932505Administrative Comment

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 30-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]09/03/04 10:43 AM, ID: 11975395Administrative Comment

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 30-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81