Thanks a lot all for your help. It worked perfectly with krishmath and vidyadhar85's suggestions...
Just Ice, thanks to you also, but as I have "-" in 3rd Gene symbol col also sometimes, thus I prefer to use column number.
Thanks a lot to all again.
---------- Post updated at 07:38 AM ---------- Previous update was at 07:20 AM ----------
Hello all,
Can anybody suggest me why the new file sizes created by all above commands differ? only first two are identical with awk...
Code:
awk '{if ($2!="-") print}' file.txt
or
Code:
awk '$2!="-" {print} ' file.txt
But with
Code:
awk '$2 ~ !/-/{print $0}' filename
and
Code:
grep -v "\-" file
provide different file size... I am comparing as my input file is same, and for this occasion I have no '-' in other cols.
Any suggestion whould be good.
Thanks,
Mitra
I guess the below command stops printing after it encounters a "-" in 2nd column.
Code:
awk '$2 ~ !/-/{print $0}' filename
The
Code:
grep -v
should work fine. Are you sure you don't have any other "-" in the file?
This User Gave Thanks to krishmaths For This Post:
Hi All,
If anybody could help me with my scenario here. I have a statement file. Example of some content:
DATE DESC Debit Credit Total Rate
02-Jan-08 Lodgement 200.00 1200.00 2.51
14-Sep-07 Withdrawal 50.00 1000.00 ... (8 Replies)
Hello Experts,
I'm a newbie so please excuse any wrong doings.
I have a file that looks like this.
abc def ghi jkl mno
def abc ghi mno jkl
ghi def mno jkl abc
I would like the file to look like this
abc def ghi jklmno
def abc ghi mnojkl
ghi def mno jklabc
in other... (3 Replies)
Hi,
I want to delete rows that have 0 at column 4.
The file looks like this:
chr01 13 61 2
chr01 65 153 0
chr01 157 309 1
chr01 313 309 0
chr01 317 469 1
chr01 473 557 0
I want to delete all rows with a 0 at column 4
chr01 13 61 2
chr01 157 309 1
chr01 ... (3 Replies)
All,
I am trying to read in a variable and search a file then delete based on that string, but i want to match exact word.
This works but it matches all, i don't want to match anthing that contains the string, just the exact string.
sed -i "/$feedname/d" file
I tried
sed... (1 Reply)
QUESTION1:
How do you grep only an exact string. I am using Solaris10 and do not have any GNU products installed.
Contents of car.txt
CAR1_KEY0
CAR1_KEY1
CAR2_KEY0
CAR2_KEY1
CAR1_KEY10
CURRENT COMMAND LINE: WHERE VARIABLE CAR_NUMBER=1 AND KEY_NUMBER=1
grep... (1 Reply)
Hi all
I have a file which looks like this
1234|1|Jon|some text|some text
1234|2|Jon|some text|some text
3453|5|Jon|some text|some text
6533|2|Kate|some text|some text
4567|3|Chris|some text|some text
4567|4|Maggie|some text|some text
8764|6|Maggie|some text|some text
My third column is my... (9 Replies)
I want to expand on a question that I just asked here:
I want to extract only those values in Column 2 that are shared by at least 2 unique values in Column 2.
Using the same input (in this case 3- tab-separated columns):
waterline-n below-sheath-v 14.8097
dock-n below-sheath-v ... (2 Replies)
Dear all,
I would like to delete even lines starting with "N" together with their respective titles which are actually odd lines.
Below is the example of input file. I would like to remove line 8 and 12 together with its title line, i.e., line 7 and 11, respectively.... (2 Replies)
06-28-2013
