How to import txt file using SQL

Home Answers Viewqa SQL How to import txt file using SQL

shasi

How to import txt file using SQL
0 Answer(s) a year 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  
**************************************************************************

View 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

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

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

txt to cvs format
file*/ import java.io.*; public class ConcatenatedFiles { static public void...){System.out.println(e);} } } how do i import the "import...txt to cvs format i am writing a simple program that read a text

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

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

Adding .txt files in a given directory
tag value as one .txt file in a given directory? I have extracted tag values but plz help me how can I save each body tag as one .txt file and add in a directory...Adding .txt files in a given directory I want to read number of XML

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

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 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

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

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

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 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

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

Convert pdf to rtf and txt - XML
Convert pdf to rtf and txt Can we convert PDF to RTF and TXT, and how? Hi Friend, Try the following codes: 1)Convert PDF to RTF import java.io.*; import java.util.*; import com.lowagie.text.*; import

Java Import Statement Cleanup - Java Tutorials
with unnecessary import statements looks unprofessional, but how do you keep... in a package, using the wildcard notation import java.awt.... and java.util.List in the same source file, then you have crossed the limits of the import

sql - SQL
.. How is it possible .. this is done in Servlets please send..., import java.sql.*; import java.io.*; import javax.servlet.*; import...(?,?)"); File file = new File("C:/apache-tomcat-5.5.20/webapps /mywork/grad_sm.gif

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

sql
sql how to get first row in sql with using where condition in sql? how to get last row in sql with using where condition in sql

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

The import Attribute of page Directive In JSP
The import Attribute of page Directive In JSP This section shows you how to import a java... or import all classes of the package by using packagename.*. Here is the code

import org.hibernate.Session error
import org.hibernate.Session error I am new to hibernate. I have... imports. what i need to do? Hi, Are you using Eclipse? Please let's...;Hi! Im using Eclipse. Steps : 1. Downloaded the example code and library from

The import keyword
compile easily finds the corresponding source file simply by using fully qualified... import statement in the beginning of the source file just to specify... The import keyword

Import object in Excel using java swing
Import object in Excel using java swing Hi sir, I want to make a swing application where I can import a object by clicking a button. I am using... to: 'insert' ribbon>select 'object'>select 'create from file' window>

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> <

SQL
SQL how to get ( 15 march 2011) and (15/03/2011) output using SQL Use the following queries to get the data from database in the given format. For (15 march 2011) format: SELECT DATE_FORMAT(dob, '%d %M %Y') FROM

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

SQL
SQL How do you increase performance of a query? Using batch, pagination, increasing JVM memory size

Importing data into sql plus from a text file...
Importing data into sql plus from a text file... How to import a text file into oracle 10g enterprise edition directly to create tables and data

Packages and Import
); } } Classes can be specified explicitly on import instead of using the wildcard... file (.class or .jar) larger? A: No, import only tells the compiler where to look... names. This is very bad. Using "*" to import all classes prevents

Import java IO - Java Beginners
Import java IO for example i know java IO is for input and output. I am using Netbeans5.5.1. How can i see all the classes related to java IO for example; stream reader, buffer reader

swing application to import a object in a excel
swing application to import a object in a excel Hi sir, I want to make a swing application where I can import a object in a cell of a excel by clicking a button. I am using Apache POI for this. after a long try I am not able

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

SQL query - SQL
SQL query hi sir/Madam i am using MS Access where i have table... to increase if the student doesnt pay for next 10days so would you suggest me how... code: import java.sql.*; import java.awt.*; import java.util.*; import

Reply to the mail(import files error)
Reply to the mail(import files error) Hi Its already there in the bin. If its class path should be set , how can i do dat? Hi, Wait for 20 minutes. I will send you link to download new project file. You should

How to import a package
How to import a package ...(); Using an "import" keyword: For example, import world.*; // we can call

insert rows from browsed file to sql database
insert rows from browsed file to sql database i need to insert rows... the databases using odbc i can do this. but after browsing and uploaded the file, content of the file has to go to database. how can i insert record into database

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

How to Read a file line by line using BufferedReader?
How to Read a file line by line using BufferedReader? Hello Java... to Read a file line by line using BufferedReader, efficiently and using less memory... problem is to find the best way to read the file in Java. I just searched the google

SQL Example, Codes and Tutorials
. In this tutorial you will learn how to you user SQL to interact with database. We have... by using the Database name. In SQL the key word 'Show databases' finds...; SQL Alias In SQL we can give a table or column another name by using

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics