How to import txt file using SQL

Ads

 
 
 

Share on Google+Share on Google+

shasi
How to import txt file using SQL
0 Answer(s)      5 years and a month ago
Posted in : 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  
**************************************************************************
Ads
View Answers
Ads









Related Tutorials/Questions & Answers:
How to import txt file using SQL
How to import txt file using SQL  Hai, I have a log file in .txt... particular words and insert onto a table using SQL. I want the output of the table... is it possible in SQL, If possible tell the script. **** Notification : 8020374
How to select only .txt file to be zipped using java?
How to select only .txt file to be zipped using java?  Hello, i'm trying to zipp .txt files from a folder but i want to know how to select only .txt...() { public boolean accept(File dir, String name) { return !name.startsWith(".txt
Advertisements
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
".txt" to sql with JDBC
".txt" to sql with JDBC  how to insert ".txt" into sql result[BLOB] with JDBC
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
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
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
Backup Into txt File
Backup Into txt File       Backup Into txt File is used to put the backup file from a ... illustrate an example from 'Backup Into txt File'. To understand this example
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
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
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
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
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
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
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
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
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
Backup selected records into txt file
Backup selected records into txt file       Backup selected records into txt file is used to copies... into txt file. To restore the selected backup records into txt file, we create
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
Backup Into txt File
Backup Into txt File       Backup Into txt File is used to put the backup file from... The Tutorial illustrate an example from 'Backup Into txt File
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 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... Selected records into txt file. To restore the selected backup records into txt
Import MYSQL file in PHP - PHP
Import MYSQL file in PHP  i wanted to import the mysql file in PHP5 on button click. is it possible to do it? Is there any possibility of data security
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
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 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
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
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
Tutorials   
Java Spring Hibernate Struts Training How to Fetch Data using dropdown option How to get day from date in SQL? Example of sorting results in MySQL Distinct and Limit example in MySQL How to download install and use MySQL workbench? Example of Average, Sum, Min and Max functions in MySQL How to delete data from MySQL? Update SQL Query Example Order by example in MySQL AND and OR Operators in MySQL Query Where clause with query in MySQL How to use select Statement in MySQL? How to insert data into MySQL Table? Create Database and tables in MySQL example of before insert trigger in mysql Failed to Call Procedure MY Sql Query Error - Not able to Understand the issue which query will be run for previous(button) question How to access data yearly from DB in C# ? Fastest way to upload huge raw data in database - c#, Java or stored procedure DB Insert Nb hours between 2 time stamps meets specific criteria mysql select into table from another table example MySQLselect into new table Example code How to create a .mdf file from script (.sql) Please help me out fixing broken relational links in MySQL database after an upgrade How do I upgrade mysql? mysql 4.x to 5.x upgrade problem Upgrading a PHP/MYSQL application? upgrading sql query join phpmyadmin in whm whm php version update php cpanel cpanel mysql downgrade cpanel mysql version upgrade mysql whm upgrade mysql 4 5 cpanel upgrade mysql cpanel server Did my upgrade from mySQL 5.1 to 5.5 work Upgrade to MySQL 5.5 ? - cPanel Mem use upgrade from MySQL 5.1 to 5.5 - cPanel Upgrading MySQL from 5.0 to 5.1 or 5.5 - cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel Updating from MySQL 5.0 to 5.5 cPanel MySQL 5.1 upgrade to 5.5 error Charset problem upon publishing PHP + MySQL website MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist SQL Error Version 5.5.15

Ads

 
Advertisement null

Ads