|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
modify file using awk
Post 20032 by Kelam_Magnus on Friday 19th of April 2002 10:01:07 AM
04-19-2002
grep, grep, grep -v
grep is what you are looking for.
First use ^$ to remove any blank lines, then grep -v to remove unique lines in the file. Then redirect to a new filename.
cat filename |grep -v ^$ |grep -v "unique header" |grep -v "unique footer" > new.filename
Remember the -v option for grep will remove/ignore lines and send the rest to standard out.
First use ^$ to remove any blank lines, then grep -v to remove unique lines in the file. Then redirect to a new filename.
cat filename |grep -v ^$ |grep -v "unique header" |grep -v "unique footer" > new.filename
Remember the -v option for grep will remove/ignore lines and send the rest to standard out.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear Folks,
I have a command output something like:
And I want to store PIN0 and SIG0 in two shell variables, now I do a double awk:
PIN=`gsmctl -d /dev/ttyS0 pin sig | awk '/PIN0/ { print $2}'`
SIG=`gsmctl -d /dev/ttyS0 pin sig | awk '/SIG0/ { print $2}'`
It's possible to... (4 Replies)
Discussion started by: Santi
4 Replies
2. Shell Programming and Scripting
Hi *
I've just wanted to ask you if it's possible to modify the input file by using awk.
Let me explain what I need:
I need to change the value $4 from "defaults" to "nodev" in my text file. I've tried to use a string function called "sub" and it works. But I can't figure it out how to... (6 Replies)
Discussion started by: martinp111
6 Replies
3. Shell Programming and Scripting
Hello,
I have 2 files. One has a list of serial numbers:
12345_7
2345_9
35454
4759:1
PEP8794
The other is an excel file, with multiple columns, separated by tab:
12345_7 ... ... .. .. .. .. ..
2345_9 ... ... .. .. .. .. ..
35454 ... ... .. .. .. .. ..
4759:1 ...... (4 Replies)
Discussion started by: ad23
4 Replies
4. Shell Programming and Scripting
Hi All,
I need help from any of you.Would be so thankful for your help.
I/P
DDDD,1045,161,1557,429,1694,800,1911,1113,2460,1457,2917>
1609,3113,1869,3317,2732,3701,3727,4132,5857,5107>
9004,6496
DDDD,1125,157,1558,429,1694,800,1911,1117,2432,1444,2906>... (2 Replies)
Discussion started by: Indra2011
2 Replies
5. Shell Programming and Scripting
awk "BEGIN {if($PERCENT<$WARNING)
{print \"OK\" ; exit 0}
else if(($PERCENT>=$WARNING) && ($PERCENT<$CRITICAL))
{print \"WARNING\" ; exit 1}
else if($PERCENT>=$CRITICAL)
{print \"CRITICAL\" ; exit 2}
}"
how can i... (1 Reply)
Discussion started by: SkySmart
1 Replies
6. Shell Programming and Scripting
how do i modify the following:
echo "jaba law welcome no jaba law sorry now jaba law" | awk '{s+=gsub(/jaba law/,"jaba law")} END {print s}'
so that it shows me the actual phrase it found matching the strings i specified?
something like:
jaba law jaba law jaba law (4 Replies)
Discussion started by: SkySmart
4 Replies
7. Shell Programming and Scripting
I have text file with lines as shown here. Each row has 11 columns separated by tab. In each row, i want to split the 8th column such that the output should look like shown below. Here value in the 9th column is DP value and in the 10th column is MQ value followed by the values after resource.EFF=.... (15 Replies)
Discussion started by: mehar
15 Replies
8. Shell Programming and Scripting
Hi Guys,
i world like to do the following with awk,
i have the the complete username
example in a file a have some names
Mario Rossi
John Doe
i would like to convert this name in this format from file with awk
Mario,Rossi,"Mario Rossi ",m.rossi_ext@mydomain.com,$TRUE,
John,Doe,"John... (7 Replies)
Discussion started by: charli1
7 Replies
9. Shell Programming and Scripting
Hello everyone!
I have thousands of csv files I have to import into a Database table. As usually the files aren't perfect. For example they have a different number of columns and some weird columns.
The second problem is, that I have to add 3 parts of the filename into 3 rows in the... (6 Replies)
Discussion started by: elRonaldo
6 Replies
10. UNIX for Beginners Questions & Answers
Hello everybody,
I would like modify some strings using sed or another command line with the content file.
For example:
- {fqdn: "server-01" , ip: "server-01"}
- {fqdn: "server-02" , ip: "server-02"}
- {fqdn: "server-03" , ip: "server-03"}
- {fqdn: "server-04" , ip: "server-04"}
My... (4 Replies)
Discussion started by: dco
4 Replies
LEARN ABOUT BSD
zgrep
ZGREP(1) General Commands Manual ZGREP(1) NAME
zgrep - search possibly compressed files for a regular expression SYNOPSIS
zgrep [ grep_options ] [ -e ] pattern filename... DESCRIPTION
Zgrep invokes grep on compressed or gzipped files. These grep options will cause zgrep to terminate with an error code: (-[drRzZ]|--di*|--exc*|--inc*|--rec*|--nu*). All other options specified are passed directly to grep. If no file is specified, then the standard input is decompressed if necessary and fed to grep. Otherwise the given files are uncompressed if necessary and fed to grep. If the GREP environment variable is set, zgrep uses it as the grep program to be invoked. EXIT CODE
2 - An option that is not supported was specified. AUTHOR
Charles Levert (charles@comm.polymtl.ca) SEE ALSO
grep(1), gzexe(1), gzip(1), zdiff(1), zforce(1), zmore(1), znew(1) ZGREP(1)