07-31-2009
Print entire line based on value in a column
Friends,
File1.txt
abc|0|xyz
123|129|opq
def|0|678
890|pqw|sdf
How do I print the entire line where second column has value is 0?
Expected Result:
abc|0|xyz
def|0|678
Thanks,
Prashant
---------- Post updated at 02:14 PM ---------- Previous update was at 02:06 PM ----------
Never mind. I should have search the forum before I open a new post.
awk -F'|' '$2=="0" File1.txt > outfile
Sorry.
Prashant
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hey gurus,
my-build1-abc
my-build10-abc
my-build2-abc
my-build22-abc
my-build3-abc
basically i want to numerically sort the entire lines based on the build number. I dont zero pad the numbers because thats "how it is" ;-)
sort -n won't work because it starts from the beginning.
... (10 Replies)
Discussion started by: gurpal2000
10 Replies
2. Shell Programming and Scripting
I'm having problems since few days ago, and i'm not able to make it works with a simple awk+grep script (or other way to do this).
For example, i have a input file1.txt:
cat inputfile1.txt
218299910417
1172051195
1172070231
1172073514
1183135117
1183135118
1183135119
1281440202
... (3 Replies)
Discussion started by: poliver
3 Replies
3. Shell Programming and Scripting
I hope this is a basic question.
I have a file with a bunch of strings in each line (and the string number is variable).
What I want to do is a simple if command and then print the entire line.
something like awk '{if ($3=="yes") print $1,$2,$3,...$X }' infile > outfile
Can someone... (1 Reply)
Discussion started by: dcfargo
1 Replies
4. Shell Programming and Scripting
Friends,
I have .txt file with 3 millions of rows.
File1.txt
ABC1|A|ABCD1|XYZ1
ABC2|P|ABCD2|XYZ2
ABC3|A|ABCD3|XYZ3
ABC4|P|ABCD4|XYZ4
If second field has value P then print the entire line.
Thanks in advance for your help,
Prashant (4 Replies)
Discussion started by: ppat7046
4 Replies
5. Shell Programming and Scripting
Hi,
I have a file whose lines are something like
Tchampionspsq^@~^@^^^A^@^@^@^A^A^Aÿð^@^@^@^@^@^@^@^@^@^@^A^@^@^@^@^?ð^@^@^@^@^@^@^@?ð^@^@^@^@^@^@pppsq^@~^@#@^@^@^@^@^@^Hw^H^@^@^@^K^@^@^@^@xp^At^@^FTtime2psq^@ ~^@^^^A^@^@^@^B^A
I need to extract all words matching T*psq from the file.
Thing is... (4 Replies)
Discussion started by: shekhar2010us
4 Replies
6. Shell Programming and Scripting
$ cat file.log
Message Number = : Sending message 10:50:16^|^reqhdr.dummyid^=^02^|^reqhdr.timezone^=^GMT+05:30^|^DUMMYREQUEST^=^BH||||||||||||||||||$BD|OL|C|V||DummyAcctNo|02||24/12/2011|ST_DDM|DDM||||||||reqUUID110612105016$BT||||||||||||||||||$] Length
I have the above line in the... (4 Replies)
Discussion started by: kalidass
4 Replies
7. Shell Programming and Scripting
Hi All,
I have a file testarun.txt contains the below lines and i want to print the lines if the character positions 7-8 matches 01.
201401011111
201401022222
201402013333
201402024444
201403015555
201403026666
201404017777
201404028888
201405019999
201405020000
I am trying the... (4 Replies)
Discussion started by: Arunprasad
4 Replies
8. Shell Programming and Scripting
Hello Everyone,
I have a file with 5 fields in each line just like mentioned below. Also the 4th field is time elapsed(hh:mm:ss) since the process is running
xyz abc status 23:00:00 idle
abc def status 24:00:00 idle
def gji status 27:00:02 idle
fgh gty status 00:00:00 idle
Here I... (8 Replies)
Discussion started by: rahul2662
8 Replies
9. Shell Programming and Scripting
I have one requirement to delete all lines from a file if it matches below scenario. File contains three column. Employee Number, Employee Name and Employee ID
Scenario is: delete all line if Employee Number (1st column) contains below
1. Non-numeric Employee Number
2. Employee Number that... (3 Replies)
Discussion started by: anshu ranjan
3 Replies
10. Shell Programming and Scripting
I have a file with class c IP addresses that I need to match to a column and print the matching lines of another file.
I started playing with grep -if file01.out file02.out but I am stuck as to how to match it to a column and print the matching lines;
cat file01.out
10.150.140... (5 Replies)
Discussion started by: lewk
5 Replies
sdiff(1) General Commands Manual sdiff(1)
NAME
sdiff - side-by-side difference program
SYNOPSIS
[options ...] file1 file2
DESCRIPTION
uses the output of diff(1) with the option, which ignores trailing blanks (spaces and tabs) and treats other strings of blanks as equal, to
produce a side-by-side listing of two files, indicating those lines that are different. Each line of the two files is printed with a blank
gutter between them if the lines are identical, a in the gutter if the line only exists in file1, a in the gutter if the line only exists
in file2, and a for lines that are different.
For example:
abc | xyz
abc abc
bca <
cba <
dcb dcb
> cde
Options
recognizes the following options:
Use the next argument,
n, as the width of the output line. The maximum value of n is 2048 (LINE_MAX). The default line length is 130 charac-
ters.
Only print on the left side when lines are identical.
Do not print identical lines.
Use the next argument,
output, as the name of a third file that is created as a user-controlled merging of file1 and file2. Identical lines of
file1 and file2 are copied to output. Sets of differences, as produced by diff(1), are printed; where a set of differ-
ences share a common gutter character. After printing each set of differences, prompts the user with a and waits for
one of the following user-typed commands:
append the left column to the output file
append the right column to the output file
turn on silent mode; do not print identical lines
turn off silent mode
call the editor with the left column
call the editor with the right column
call the editor with the concatenation of left and right
call the editor with a zero length file
exit from the program
On exit from the editor, the resulting file is concatenated on the end of the output file.
EXAMPLES
Print a side-by-side diff of two versions of a file on a printer capable of printing 132 columns:
Retrieve the most recently checked in version of a file from RCS and compare it with the version currently checked out:
SEE ALSO
diff(1), ed(1).
sdiff(1)