08-08-2010
awk removing data before or after a pattern
I have the following data:
01:00:00 29 10 20 41
01:20:00 18 6 34 42
01:40:00 28 5 24 43
02:00:01 11 7 8 74
02:20:01 19 15 12 54
02:40:01 1 4 0 95
03:00:01 1 3 0 96
03:20:01 0 0 0 99
03:40:01 1 2 0 97
First I want to remove all data after a certain pattern, Ie 03:00 sp this
should leave me with the following results
01:00:00 29 10 20 41
01:20:00 18 6 34 42
01:40:00 28 5 24 43
02:00:01 11 7 8 74
02:20:01 19 15 12 54
02:40:01 1 4 0 95
03:00:01 1 3 0 96
Secondly I would also like to know how to remove all before the pattern
so this should leave me with the following results.
03:00:01 1 3 0 96
03:20:01 0 0 0 99
03:40:01 1 2 0 97
Note: Both these statements not be run at the same time.
Thanks to all who answer.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i need to use sed to remove an entire line containing a pattern stored in a variable say $var1
this var1 will be a URL and will therefore contain slashes
any help would be greatly appreciated (1 Reply)
Discussion started by: Fire_Storm
1 Replies
2. Shell Programming and Scripting
Input:
>abc|123456|def|EXIT|
>abc|203456|def|EXIT2|
>abc|234056|def|EXIT3|
>abc|340056|def|EXIT4|
>abc|456000|def|EXIT5|
.
.
.
Output:
def|EXIT|
def|EXIT2|
def|EXIT3|
def|EXIT4|
def|EXIT5|
.
.
My try code: (9 Replies)
Discussion started by: patrick87
9 Replies
3. Shell Programming and Scripting
Hi all,
I have the following script, but are not too sure about the syntax to complete the script.
In essence, the script must connect to a SFTP server at a client site with username and password located in a file on my server.
Then change to the appropriate directory.
Pull the data to the... (1 Reply)
Discussion started by: codenjanod
1 Replies
4. Shell Programming and Scripting
I have the following:
HH:MM:SS
I want to use either % or # sign to remove :SS can somebody please provide me an example. I know how to do this in awk, but awk is too much
overhead for something this simple since I will be doing this in a loop a lot of times.
Thanks in advance to all... (2 Replies)
Discussion started by: BeefStu
2 Replies
5. Shell Programming and Scripting
Hey Guys!
I have written a code which combines lots of files into one big file(.csv).
However, each of the original files had headers on the first line, and now that I've combined the files the headers are interspersed throughout the new combined data frame. For example, throughout the data... (21 Replies)
Discussion started by: gd9629
21 Replies
6. Shell Programming and Scripting
I have a binary (hex) file I need to parse to get some data which are encoded this way:
.* b4 . . . 01 12 .* af .* 83 L1 x1 x2 xL 84 L2 y1 y2 yL
By another words there is a stream of hexadecimal bytes (in my example separated by space for better readability). I need to get value stored in... (3 Replies)
Discussion started by: sameucho
3 Replies
7. Shell Programming and Scripting
I am on ubuntu 11.10 using bash scripts
I want to remove all files matching a string pattern and I am using the following code
find . -name "*$pattern*" -exec rm -f {} \;I have encountered a problem when $pattern is empty. In this case all my files in my current directory were deleted. This... (3 Replies)
Discussion started by: kristinu
3 Replies
8. Shell Programming and Scripting
Dear team,
I have a file curve.csv which is generated from oracle and each line has a comment associated with it, I want to get rid of this comment, can you please suggest me a command as how to do it
Eg,
cat curve.csv
/*data for today curve*/
/*data for text1*/ this is the header
/*data... (6 Replies)
Discussion started by: infyanurag
6 Replies
9. UNIX for Dummies Questions & Answers
Hi Everybody! First post! Totally noobie.
I'm using the terminal to read a poorly formatted book.
The text file contains, in the middle of paragraphs, hyphenation to split words that are supposed to be on multiple pages. It looks ve -- ry much like this.
I was hoping to use grep -v " -- "... (5 Replies)
Discussion started by: AxeHandle
5 Replies
10. Shell Programming and Scripting
im using the following code to grab data, but after the data in the range im specifying has been grabbed, i want to count how many instances of a particular pattern is found?
awk 'BEGIN{count=0} /parmlib.*RSP/,/seqfiles.*SSD/ {print; count++ } /103 error in ata file/ END { print count }'... (3 Replies)
Discussion started by: SkySmart
3 Replies
LEARN ABOUT LINUX
debconf-copydb
DEBCONF-COPYDB(1) Debconf DEBCONF-COPYDB(1)
NAME
debconf-copydb - copy a debconf database
SYNOPSIS
debconf-copydb sourcedb destdb [--pattern=pattern] [--owner-pattern=pattern] [--config=Foo:bar]
DESCRIPTION
debconf-copydb copies items from an existing debconf database into another, possibly new database. The two databases may have different
formats; if so a conversion will automatically be done.
OPTIONS
sourcedb
The name of the source database. Typically it will be defined in your debconf.conf (or .debconfrc) file.
destdb
The name of the destination database. It may be defined in debconf.conf or .debconfrc, or you might define it on the command line (see
below).
-p pattern, --pattern pattern
If this is specified, only items in sourcedb whose names match the pattern will be copied.
--owner-pattern pattern
If this is specified, only items in sourcedb whose owners match the pattern will be copied.
-c foo:bar, --config Foo:bar
Set option Foo to bar. This is similar to writing:
Foo: bar
In debconf.conf, except you probably want to leave off the space on the command line (or quote it: "Foo: bar"). Generally must be used
multiple times, to build up a full configuration stanza. While blank lines are used to separate stanzas in debconf.conf, this program
will assume that "Name:dbname" denotes the beginning of a new stanza.
EXAMPLES
debconf-copydb configdb backup
Copy all of configdb to backup, assuming you already have the backup database defined in debconf.conf.
debconf-copydb configdb newdb --pattern='^slrn/'
--config=Name:newdb --config=Driver:File
--config=Filename:newdb.dat
Copy slrn's data out of configdb, and into newdb. newdb is not defined in the rc file, so the --config switches set up the database on the
fly.
debconf-copydb configdb stdout -c Name:stdout -c Driver:Pipe
-c InFd:none --pattern='^foo/'
Spit out all the items in the debconf database related to package foo.
debconf-copydb configdb pipe --config=Name:pipe
--config=Driver:Pipe --config=InFd:none |
ssh remotehost debconf-copydb pipe configdb
--config=Name:pipe --config=Driver:Pipe
This uses the special purpose pipe driver to copy a database to a remote system.
SEE ALSO
debconf.conf(5)
AUTHOR
Joey Hess <joeyh@debian.org>
2011-06-22 DEBCONF-COPYDB(1)