How to import txt file using SQL

Hai, I have a log file in .txt format and format of the log is given below. From the log i want to pick up some particular words and insert onto a table using SQL. I want the output of the table like

occurred Time      pcmcircuit unavailableSec

04/14/12 10:07:33   77         32
04/14/12 10:20:10   15         43291 
.
.
.
04/14/12 10:20:10   15         4329
.
04/14/12 10:07:33   77         32
and so on....

SO please tell me is it possible in SQL, If possible tell the script.

**** Notification : 8020374 ********** SEVERITY : CLEARED ****************
occurred on 04/14/12 10:07:33  -  received on 04/14/12 10:07:31  
Type        : communicationsAlarm
Instance    : bsc 13   | pcmCircuit 77
Description : IMPHAL
- Information on fault -------------------------
    Probable cause      : (29) lossOfSignal
    Fault number        : (2009) PCM FAILURE
- Manufacturer Information ---------------------
    "E1L PCM Fault End Time"
- Other information ----------------------------
PCM failure : Hardware Slot Position : 
        shelfNumber : 1
        positionInShelf : 12
    portNumber : 14
    pcmType : pcmAbis
    thresholdInfo : 10
    unavailabSec : 32

    Notification at MDlevel : 8643316  - received on 04/14/12 10:07:31  
**************************************************************************




**** Notification : 8020723 ********** SEVERITY : CLEARED ****************
occurred on 04/14/12 10:20:10  -  received on 04/14/12 10:20:18  
Type        : communicationsAlarm
Instance    : bsc 13   | pcmCircuit 15
Description : IMPHAL
- Information on fault -------------------------
    Probable cause      : (29) lossOfSignal
    Fault number        : (2009) PCM FAILURE
- Manufacturer Information ---------------------
    "E1L PCM Fault End Time"
- Other information ----------------------------
PCM failure : Hardware Slot Position : 
        shelfNumber : 0
        positionInShelf : 5
    portNumber : 15
    pcmType : pcmAbis
    thresholdInfo : 10
    unavailabSec : 43291

    Notification at MDlevel : 8643712  - received on 04/14/12 10:20:18  
**************************************************************************




**** Notification : 8020828 ********** SEVERITY : CLEARED ****************
occurred on 04/14/12 10:22:40  -  received on 04/14/12 10:22:38  
Type        : communicationsAlarm
Instance    : bsc 13   | pcmCircuit 50
Description : IMPHAL
- Information on fault -------------------------
    Probable cause      : (29) lossOfSignal
    Fault number        : (2009) PCM FAILURE
- Manufacturer Information ---------------------
    "E1L PCM Fault End Time"
- Other information ----------------------------
PCM failure : Hardware Slot Position : 
        shelfNumber : 1
        positionInShelf : 9
    portNumber : 8
    pcmType : pcmAbis
    thresholdInfo : 10
    unavailabSec : 13744

    Notification at MDlevel : 8643824  - received on 04/14/12 10:22:38  
**************************************************************************




**** Notification : 8021678 ********** SEVERITY : CLEARED ****************
occurred on 04/14/12 10:45:43  -  received on 04/14/12 10:45:42  
Type        : communicationsAlarm
Instance    : bsc 13   | pcmCircuit 82
Description : IMPHAL
- Information on fault -------------------------
    Probable cause      : (29) lossOfSignal
    Fault number        : (2009) PCM FAILURE
- Manufacturer Information ---------------------
    "E1L PCM Fault End Time"
- Other information ----------------------------
PCM failure : Hardware Slot Position : 
        shelfNumber : 1
        positionInShelf : 12
    portNumber : 19
    pcmType : pcmAbis
    thresholdInfo : 10
    unavailabSec : 11576

    Notification at MDlevel : 8644757  - received on 04/14/12 10:45:42  
**************************************************************************




**** Notification : 8021804 ********** SEVERITY : CLEARED ****************
occurred on 04/14/12 10:49:39  -  received on 04/14/12 10:49:37  
Type        : communicationsAlarm
Instance    : bsc 13   | pcmCircuit 72
Description : IMPHAL
- Information on fault -------------------------
    Probable cause      : (29) lossOfSignal
    Fault number        : (2009) PCM FAILURE
- Manufacturer Information ---------------------
    "E1L PCM Fault End Time"
- Other information ----------------------------
PCM failure : Hardware Slot Position : 
        shelfNumber : 1
        positionInShelf : 12
    portNumber : 9
    pcmType : pcmAbis
    thresholdInfo : 10
    unavailabSec : 4824

    Notification at MDlevel : 8644897  - received on 04/14/12 10:49:37  
**************************************************************************




**** Notification : 8022129 ********** SEVERITY : CLEARED ****************
occurred on 04/14/12 10:56:06  -  received on 04/14/12 10:56:04  
Type        : communicationsAlarm
Instance    : bsc 13   | pcmCircuit 76
Description : IMPHAL
- Information on fault -------------------------
    Probable cause      : (29) lossOfSignal
    Fault number        : (2009) PCM FAILURE
- Manufacturer Information ---------------------
    "E1L PCM Fault End Time"
- Other information ----------------------------
PCM failure : Hardware Slot Position : 
        shelfNumber : 1
        positionInShelf : 12
    portNumber : 13
    pcmType : pcmAbis
    thresholdInfo : 10
    unavailabSec : 53165

    Notification at MDlevel : 8645245  - received on 04/14/12 10:56:04  
**************************************************************************




**** Notification : 8022215 ********** SEVERITY : CLEARED ****************
occurred on 04/14/12 10:58:00  -  received on 04/14/12 10:57:59  
Type        : communicationsAlarm
Instance    : bsc 13   | pcmCircuit 16
Description : IMPHAL
- Information on fault -------------------------
    Probable cause      : (29) lossOfSignal
    Fault number        : (2009) PCM FAILURE
- Manufacturer Information ---------------------
    "E1L PCM Fault End Time"
- Other information ----------------------------
PCM failure : Hardware Slot Position : 
        shelfNumber : 0
        positionInShelf : 5
    portNumber : 16
    pcmType : pcmAbis
    thresholdInfo : 10
    unavailabSec : 12151

    Notification at MDlevel : 8645341  - received on 04/14/12 10:57:59  
**************************************************************************




**** Notification : 8022641 ********** SEVERITY : major ******************
occurred on 04/14/12 11:16:24  -  received on 04/14/12 11:16:22  
Type        : communicationsAlarm
Instance    : bsc 13   | pcmCircuit 77
Description : IMPHAL
- Information on fault -------------------------
    Probable cause      : (29) lossOfSignal
    Fault number        : (2009) PCM FAILURE
- Manufacturer Information ---------------------
    "E1L PCM Fault Begin Time"
- Other information ----------------------------
PCM failure : Hardware Slot Position : 
        shelfNumber : 1
        positionInShelf : 3
    portNumber : 15
    pcmType : pcmAbis
    thresholdInfo : 5
    ndSecLos : 0
    ndSecAis : 5
    ndSecLfa : 0
    ndSecFe : 0
    ndSecCrc : 0
    ndSecRai : 0
    ndSecEBits : 0

    Notification at MDlevel : 8645822  - received on 04/14/12 11:16:22  
**************************************************************************

View Answers

Advertisements

".txt" to sql with JDBC
".txt" to sql with JDBC how to insert ".txt" into sql result[BLOB] with JDBC

how to change file from .txt to .mat(matrix)
how to change file from .txt to .mat(matrix) i have a big file.txt and i want to change this file to file.mat(matrix) ...this is in windows not on any os ..thx if u answering quickly please

How to import data from sql server table into an excel file by creating the rows dynamically in the excel according to the dataabase??
How to import data from sql server table into an excel file by creating the rows dynamically in the excel according to the dataabase?? How to import data from sql server table into an excel file by creating the rows dynamically

Convesion of txt file to doc file.??????
Convesion of txt file to doc file.?????? how to convert text file to doc file using java

Thread for reading txt file
Thread for reading txt file how to use 3 thread to read 3 txt file? To create three threads for reading the file and three threads for getting the strings out of the queue and printing them. thanks

Backup Into txt File
Backup Into txt File Backup Into txt File is used to put the backup file from a ... The Tutorial illustrate an example from 'Backup Into txt File

ModuleNotFoundError: No module named 'file_open_gips_txt'
named 'file_open_gips_txt' How to remove the ModuleNotFoundError: No module named 'file_open_gips_txt' error? Thanks Hi, In your...ModuleNotFoundError: No module named 'file_open_gips_txt' Hi, My

Creating a File I/O using import scanner, io.* and text.*
Creating a File I/O using import scanner, io.* and text.* open a file for reading and open another file for writing data. input file hours-int, hourly rate-double, name-string. output file name-string, hours-int, hourly rate

Uploading and download pdf or .txt file.
Uploading and download pdf or .txt file. I want admin user to upload pdf file into database and the users can download those pdf format from database

How do I import a CSV file in R?
How do I import a CSV file in R? Hi, I have a CSV file with 900000 records and I want to load it for analytics. How do I import a CSV file in R... file: data = read.csv("data.csv", header = TRUE) Above code loads the data

ModuleNotFoundError: No module named 'odoo12-addon-account-bank-statement-import-txt-xlsx'
-import-txt-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-account-bank-statement-import-txt-xlsx' error? Thanks ...-import-txt-xlsx' Hi, My Python program is throwing following error

import file
import file public void importFile(BlobDomain fileData) { InputStream inStr = fileData.getInputStream(); Workbook workbook... need POI library. Download zip file from the following link: http

How to read data from txt file and save to database MySql - Java Beginners
How to read data from txt file and save to database MySql Please help me again ,my problem right know is how to read data from txt file then data... this. Thank's very much Hi friend, code to read a file import

How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile... command at the shell prompt to import sql data file: $ mysql -u username -p -h...://www.phpzag.com/import-mysql-database-command-line-import-mysql-dumpfile-sql-datafile

Shifting txt file to database - Java Beginners
Shifting txt file to database Question Details: I want to shift data from txt file to Database. The data is written in the following text format... Birth Date : 1964-12-03 Can any body help me how to fetch record

Upload CSV File into Columns of sql table using servlets and jsp
Upload CSV File into Columns of sql table using servlets and jsp Hello sir, plz give me the code to upload csv file data into respective columns of table

How to Extract SQL schema into .xsl file
How to Extract SQL schema into .xsl file how to extract SQL schema from databse into excel(.xsl) file. i need to do it in java

Backup selected records into txt file
Backup selected records into txt file Backup selected records into txt file is used to copies... Selected records into txt file. To restore the selected backup records into txt

how to connect SQL Server 2005 using php
how to connect SQL Server 2005 using php i need to connect SQL Server 2005 using php. how can i connect . how to use mssql_connect function

Backup Into txt File
Backup Into txt File Backup Into txt File is used to put the backup file from..._TO_REPLACE_1 The Tutorial illustrate an example from 'Backup Into txt File

How to zip a file using javascrip?
How to zip a file using javascrip? hi.. can anyone tell me How to zip a file using javascrip

How to write to file using FileOutputStream
How to write to file using FileOutputStream Hi friends, Please help me in java program. How to write to file using FileOutputStream? thanks, Hi, To write a file using FileOutputStream, we have to use

How to write to file using FileWriter
How to write to file using FileWriter hi, How to write to file using FileWriter thanks, Hi, To writing in a file in Java program we... of the FileWriter class can be created using the following of its constructor i.e. FileWriter

How to create a .mdf file from script (.sql)
How to create a .mdf file from script (.sql) Hi, I have a sql database in 2008 server. now i want it to convert to 2005. so i script it. just help me to create a .mdf file back from the script

How to upload file using JSP?
How to upload file using JSP? Hi all, I m the beginner in JSP, I want to upload file on server in specific folder. 1)page.jsp... file upload form to the user</TITLE></HEAD> <

convert .txt file in .csv format - Java Beginners
convert .txt file in .csv format Dear all, I hope you are doing good. I am looking to convert .txt file in .csv format. The contents might have... want export these contents to a .csv file. I am aware that I need to use

Import Data to SQL database in Java
Import Data to SQL database in Java Hi, I'm a beginner and I'm wondering how to Import Data to SQL database in Java? Thanks (Platform: Eclipse/SQL

Remove JTable row that read txt file records
Remove JTable row that read txt file records Hi every one. i have a jtable that correctly read data frome file and show them in own. I want to add... occur. my whole code is this: import java.awt.event.ActionEvent

how to export the query result in SQL Server to .csv file?
how to export the query result in SQL Server to .csv file? how to write table data into CSV file using SQL SERVER 2008

Backup selected records into txt file
Backup selected records into txt file Backup selected records into txt file is used... a Example from Backup Selected records into txt file. To restore the selected backup

jfree missing import file
jfree missing import file hi....... i have checked the jar file of jfree that import file of RECTANGLEINSETS is not there then what to do now? how.... This jar contains the required class file

how to delete a row in sql without using delete command.
how to delete a row in sql without using delete command. how to delete a row in sql without using delete command. thanks in advance

How to insert image in sql database from user using servlet
How to insert image in sql database from user using servlet pls tell me accept image from user and insert image in sql server 2005 database using servlet and jsp

how to create an excel file using java
how to create an excel file using java how to create an excel file using java

How to open a file in java using JFileChooser
How to open a file in java using JFileChooser How to open a file in java using JFileChooser

How to transfer a file in java using SSH & Telnet
How to transfer a file in java using SSH & Telnet How to transfer a file in java using SSH & Telnet

how to read file using InputStreamReader in java
how to read file using InputStreamReader in java Hi, I want to learn to use the InputStreamReader class of Java and trying to read a text file with the class. how to read file using InputStreamReader in java? Thanks

how to read and write an xml file using java
how to read and write an xml file using java Hi Can anyone help me how to read and write an xml file which has CData using java

how to create pdf file using java and itextjar
how to create pdf file using java and itextjar How to create pdf file having paragraphs and alignments done using java and itextjar 5.10 version.? hope i get quick response

How to Split a large XML file using java?
How to Split a large XML file using java? How can we split a 500MB Xml file?I know how to split xml file after reading the entire document in a file.Here we cannot load the entire file as it is a large file

how to upload file using FTP in java
how to upload file using FTP in java hai, i want to upload file using FTP in java Webservices.. Tel me some Articles Regards Asha

How to import txt file using SQL

Questions by Category