Hi....can you guys help me out in this script??
Below is a text file script....called Bukom.txt and it contains these:
BUKOM 20060101 2.5 2.6 2.7 2.8 2.9 2.3 2.1
BUKOM 20060102 2.4 2.5 2.6 2.7 2.7 2.6 2.4
BUKOM 20060103 2.1 ... (9 Replies)
Hi,
Need to get help from you guys about this issue.
I need to insert data into MySql database from a text file which is located in other server.
The text file is something look like below:
Date | SubscriberNo | Call Duration
20/7/07 | 123456788 | 20
20/7/07 | 123412344 | 30
The... (4 Replies)
Hi....can you guys help me out in this script??
Below is a text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (4 Replies)
Hi All,
I have a file like this,
data1,data2,,,data5,data6.
i want to write a shell script to replace data3 with "/example/string". which means my data file should look like this .
data1,data2,example/string],,data5,data6.
Could you guys help me to get a sed command or any other command... (8 Replies)
Hi Guys
I need to have a shell script which reads a log file and insert a part of each line into the database. Some sample lines in the file are as below.
20091112091359 MED_RQACK : user_data=60173054304,100232120,20091112091359,;ask_status=0;ask_reason=OK;msg_id=20091112091319... (5 Replies)
If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries
LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n' (0 Replies)
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
Hello All:
We are looking to search through 2000 files with around 21,000 statements where we have to search, replace and insert a pattern based on the following:
1) Parse through the file and check for CREATE MULTISET TABLE or CREATE SET TABLE statements.....and they always end with ON... (5 Replies)
I have a test file that I want to read and insert only certain lines into the
the table based on a filter.
1. Rread the log file 12 Hours back Getdate() -12 Hours
2. Extract the following information on for lines that say "DUMP is
complete"
A. Date
B. Database Name
C.... (2 Replies)
Hi Experts,
I have a situation where I need to write a shell script to continuously monitor a log directory with multiple log files and perform following:
1. Read the latest log file continuously and grep "Success" OR "Failure"
2. As it capture either Success or Failure, it has to perform a... (1 Reply)
Discussion started by: rish_max
1 Replies
LEARN ABOUT DEBIAN
sa1
SA1(8) Linux User's Manual SA1(8)NAME
sa1 - Collect and store binary data in the system activity daily data file.
SYNOPSIS
/usr/lib/sysstat/sa1 [ --boot | interval count ]
DESCRIPTION
The sa1 command is a shell procedure variant of the sadc command and handles all of the flags and parameters of that command. The sa1 com-
mand collects and stores binary data in the /var/log/sysstat/sadd file, where the dd parameter indicates the current day. The interval and
count parameters specify that the record should be written count times at interval seconds. If no arguments are given to sa1 then a single
record is written.
The sa1 command is designed to be started automatically by the cron command.
OPTIONS --boot This option tells sa1 that the sadc command should be called without specifying the interval and count parameters in order to insert
a dummy record, marking the time when the counters restarts from 0.
EXAMPLE
To collect data (including those from disks) every 10 minutes, place the following entry in your root crontab file:
0,10,20,30,40,50 * * * * /usr/lib/sysstat/sa1 1 1 -S DISK
Debian note
The Debian sysstat package has already placed such an entry in your system crontab. Please refer to the /usr/share/doc/sys-
stat/README.Debian file for details.
FILES
/var/log/sysstat/sadd
Indicate the daily data file, where the dd parameter is a number representing the day of the month.
AUTHOR
Sebastien Godard (sysstat <at> orange.fr)
SEE ALSO sar(1), sadc(8), sa2(8), sadf(1), sysstat(5)
http://pagesperso-orange.fr/sebastien.godard/
Linux FEBRUARY 2012 SA1(8)