02-06-2008
urgent-extracting block data from flat file using shell script
Hi,
I want to extract block of data from flat file.
the data will be like this
start of log
One
two
three
end of log
i want all data between start of log to end of log i.e One
two
three to be copied to another file.
This particular block may appear multiple times in same file. I want all the blocks to be directed to new file.
shirish
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Greetings All!!
I have a very peculiar problem where I have to parse a big text file and extract useful data out of it with starting and ending block pattern matching.
e.g. I have a input file like this:
sample data
block1
sample data
start
useful data
end
sample data
block2
sample... (5 Replies)
Discussion started by: arminder
5 Replies
2. Shell Programming and Scripting
Hello,
A script has been written to extract a specific column data from a text file ONLY if the user's initial input matches the the data of the first column in the text, then only the data from that row will be prinited.
The problem I am having is that the code is only reading the records... (6 Replies)
Discussion started by: jermaine4ever
6 Replies
3. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
4. Shell Programming and Scripting
There is a folder which can be accessed through URL by giving a particular Username and Password.Inside the folder there are few excel sheets.The excel sheets/folder need to be imported from there to unix box with the help of unix shell script.
Can anyone help me?Does anyone have code for it?... (2 Replies)
Discussion started by: vanur
2 Replies
5. Shell Programming and Scripting
Hi ,
I have a text file noname.txt containing 1000+ records like this. One of the record I have given below.
Input will b e like this
BOT:
2010/06/01 00:25:59
21 = "private"
Access-Method = 31
NCC = GBR
01 = "340806@osiris.fr.ft"
04 =... (2 Replies)
Discussion started by: smalya
2 Replies
6. Shell Programming and Scripting
Hi,
I need to extract a oracle staging table to a flat file thru unix batch process.We are expecting more than 4million records in the table.I know I can do it using "UTL_FILE" .But,since "UTL_FILE" takes a lot of time I am looking for better options.Can any body suggest some better options?
... (3 Replies)
Discussion started by: Beena
3 Replies
7. Shell Programming and Scripting
All,
I have a flat file which contains an email address in every line. I am trying to find a way to extract all the email addresses delimited by comma (,). Can you please show me a way, it will be very helpful, thanks. (3 Replies)
Discussion started by: sed_beginner19
3 Replies
8. Shell Programming and Scripting
hello friends,
my file is like
123 |asd|asd|asd
123_1|awd|asw|asw
121 |wer|qwe|wee
124 |weq|qwe|iop
1_23 |bla|blh|bha
145 |ghj|jkl|ghj
146 |qwe|qwe|wer
154 |asd|wer|qw_e
134_5|qwe|wer|qw_e
is their any solution to retrive only those lines which are having only 3 numerical letters... (20 Replies)
Discussion started by: PankajChawla
20 Replies
9. Shell Programming and Scripting
Hi All,
I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far.
1. Table.txt ==> database extract file
2. flat.txt ==> pipe delimited after some manipulation of the original db... (0 Replies)
Discussion started by: express14
0 Replies
10. Shell Programming and Scripting
I am trying to write a shell script which takes an input file as an arguement in the terminal e.g. bash shellscriptname.sh input.txt. I would like for the file to be read line by line each time checking if the .txt file contains certain words or letters(validating the syntax). If the line being... (1 Reply)
Discussion started by: Gurdza32
1 Replies
AC(8) BSD System Manager's Manual AC(8)
NAME
ac -- connect time accounting
SYNOPSIS
ac [-dp] [-t tty] [-w wtmp] [users ...]
DESCRIPTION
If the file /var/log/utx.log exists, a record of individual login and logout times are written to it by login(1) and init(8), respectively.
The ac utility examines these records and writes the accumulated connect time (in hours) for all logins to the standard output.
The options are as follows:
-d Display the connect times in 24 hour chunks.
-p Print individual users' totals.
-t tty Only do accounting logins on certain ttys. The tty specification can start with '!' to indicate not this tty and end with '*' to
indicate all similarly named ttys. Multiple -t flags may be specified.
-w wtmp Read connect time data from wtmp instead of the default file, /var/log/utx.log.
users ... Display totals for the given individuals only.
If no arguments are given, ac displays the total connect time for all accounts with login sessions recorded in utx.log.
The default utx.log file will increase without bound unless it is truncated. It is normally truncated by the daily scripts run by cron(8),
which rename and rotate the utx.log files, keeping a week's worth of data on hand. No login or connect time accounting is performed if
/var/log/utx.log does not exist.
FILES
/var/log/utx.log connect time accounting file
EXIT STATUS
The ac utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
Allow times recorded in modems to be charged out at a different rate than other:
ac -p -t "ttyd*" > modems
ac -p -t "!ttyd*" > other
SEE ALSO
login(1), getutxent(3), init(8), sa(8)
BSD
January 21, 2010 BSD