How to delete rows?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to delete rows?
# 1  
Old 02-20-2013
How to delete rows?

I have an Output file which has the result

Code:
YYYY 95,77
YYYY 
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY 
YYYY 
YYYY 
YYYY

I would like to display the above along with a single line with above info. Final output should be

Code:
YYYY 95
YYYY 95,77

YYYY has sources 95,77.

I cannot figure a way to delete those line without a number and to display it in a line.

Please help.

Last edited by Scrutinizer; 02-20-2013 at 10:53 AM.. Reason: code tags
# 2  
Old 02-20-2013
With grep and sort
Code:
$ grep "[0-9]" file | sort -u
YYYY 95
YYYY 95,77

with awk
Code:
$ awk '/[0-9]/ && !A[$0]++' file
YYYY 95,77
YYYY 95

# 3  
Old 02-20-2013
Hi thank you. But that is only sorting the file.

But I cannot display this info in one line/

I always get
Code:
 Corresponding Sources
  , , ,1, 196 95 95,77

Any way i can take out those spaces?

---------- Post updated at 09:16 AM ---------- Previous update was at 09:16 AM ----------

Hi thank you. But that is only sorting the file.

But I cannot display this info in one line/

I always get
Corresponding Sources
, , ,1, 196 95 95,77

Any way i can take out those spaces?

Last edited by Scrutinizer; 02-20-2013 at 10:55 AM.. Reason: code tags
# 4  
Old 02-25-2013
I have managed to get the following output:
XPAR
XPAR
XPAR ,
XPAR , ,

XPAR ,1,
XPAR 12
XPAR 19
XPAR 196
XPAR 20
XPAR 95
XPAR 95,
XPAR 95,77

But I would like to just clean up the rows which have no data/ space/ tab on the second column.

Any Ideas please.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete rows with conditions

Hi everyone, I will appreciate a lot if anyone can help me about a simple issue. I have a data file, and I need to remove some rows with a given condition. So here is a part of my data file: 5,14,1,3,3,0,0,-0.29977188269E+01 5,16,1,4,4,0,0,0.30394279900E+02... (4 Replies)
Discussion started by: hayreter
4 Replies

2. Shell Programming and Scripting

delete the same rows

each individual (row) has genotype expressed for each SNP (column) file1.txt 1 1 A G A T G T A A A A A A A A A A A A A A A A A A A A A 2 2 G A A A A A A A A A A A A A A A A A A A A A A A A A A 3 3 A A A A A A A A A A A A A A A A A A A A A A A A A A A 4 4 G A G T A T A A A A A A A A A A A... (3 Replies)
Discussion started by: johnkim0806
3 Replies

3. UNIX for Dummies Questions & Answers

delete rows with a criteria

Hi, I would like to know how can I delete rows of a text file if from the 3rd column onwards there is only zeros? Thanks in advance (7 Replies)
Discussion started by: fadista
7 Replies

4. Shell Programming and Scripting

Delete duplicate rows

Hi, This is a followup to my earlier post him mno klm 20 76 . + . klm_mango unix_00000001; alp fdc klm 123 456 . + . klm_mango unix_0000103; her tkr klm 415 439 . + . klm_mango unix_00001043; abc tvr klm 20 76 . + . klm_mango unix_00000001; abc def klm 83 84 . + . klm_mango... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

5. UNIX for Dummies Questions & Answers

Delete all rows but leaving first and last ones

Hello, Merry Christmas to all! I wish you the best for these holidays and the best for the next year 2011. I'd like your help please, I need to delete all the rows in the third column of my file, but without touching nor changing the first and last value position, this is an example of my... (2 Replies)
Discussion started by: Gery
2 Replies

6. Shell Programming and Scripting

delete the rows from the files

for example: this is the data file test.txt with more than 1000 rows 1. ccc 200 2.ddd 300 3.eee 400 4 fff 5000 ........ 1000 ddd 500 .... I would like to keep the rows with ccc and ddd, all other rows will be deleted, I still need the same output file: test.txt, how can... (5 Replies)
Discussion started by: jdsignature88
5 Replies

7. UNIX for Advanced & Expert Users

Delete rows from a file...!!

Say i have a file with X rows and Y columns....i see that in some of the rows,some columns are blank (no value set)...i wish to delete such rows....how can it be done? e.g 181766 100 2009-06-04 184443 2009-06-04 10962 151 2009-06-04 161 2009-06-04... (7 Replies)
Discussion started by: ak835
7 Replies

8. Shell Programming and Scripting

delete rows in a file based on the rows of another file

I need to delete rows based on the number of lines in a different file, I have a piece of code with me working but when I merge with my C application, it doesnt work. sed '1,'\"`wc -l < /tmp/fileyyyy`\"'d' /tmp/fileA > /tmp/filexxxx Can anyone give me an alternate solution for the above (2 Replies)
Discussion started by: Muthuraj K
2 Replies

9. Shell Programming and Scripting

how to delete duplicate rows in a file

I have a file content like below. "0000000","ABLNCYI","BOTH",1049,2058,"XYZ","5711002","","Y","","","","","","","","" "0000000","ABLNCYI","BOTH",1049,2058,"XYZ","5711002","","Y","","","","","","","","" "0000000","ABLNCYI","BOTH",1049,2058,"XYZ","5711002","","Y","","","","","","","",""... (5 Replies)
Discussion started by: vamshikrishnab
5 Replies

10. Shell Programming and Scripting

How to delete particular rows from a file

Hi I have a file having 1000 rows. Now I would like to remove 10 rows from it. Plz give me the script. Eg: input file like 4 1 4500.0 1 5 1 1.0 30 6 1 1.0 4500 7 1 4.0 730 7 2 500000.0 730 8 1 785460.0 45 8 7 94255.0 30 9 1 31800.0 30 9 4 36000.0 30 10 1 15000.0 30... (5 Replies)
Discussion started by: suresh3566
5 Replies
Login or Register to Ask a Question