Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How To Erase a line is a row is empty?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How To Erase a line is a row is empty?
# 1  
Old 05-10-2011
Error How To Erase a line is a row is empty?
Hi! i've been reading you guys for some time, now there is something I couldn't find here,

I'm trying to purge some data for my thesis but my measurements have some gaps in the third columns.

The solution is simple,
-Erase those lines where the third column is empty

¿How?

example file:
Code:
data.dat

052	0.200	0.655690
052	0.201	
052	0.202	
052	0.203	
052	0.204	
052	0.205	
052	0.206	
052	0.207	
052	0.208	
052	0.209	
052	0.210	0.621856

# 2  
Old 05-10-2011
Code:
awk 'NF>2' data.dat

This User Gave Thanks to bartus11 For This Post:
AriasFco
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need a program that read a file line by line and prints out lines 1, 2 & 3 after an empty line...

Hello, I need a program that read a file line by line and prints out lines 1, 2 & 3 after an empty line... An example of entries in the file would be: SRVXPAPI001 ERRO JUN24 07:28:34 1775 REASON= 0000, PROCID= #E506 #1065: TPCIPPR, INDEX= 003F ... (8 Replies)
Discussion started by: Ferocci
8 Replies

2. UNIX for Dummies Questions & Answers

Insert row into empty file...how?

Greetings: I generate an empty flat file just fine when there's no data returned from my process, as the customer wants one always (using the 1st line of the below script). However, they also want at least the column names in this flat file (row 1, the only row to be in the emply file). I'm... (7 Replies)
Discussion started by: Benrosa
7 Replies

3. Programming

[SOLVED] C++ print next line until line.empty

Hi, could you please help with the following: I have an input file like: one two three four five six I want to print the lines starting from 'three' to the empty line. Something like that: if ( line == "three" ) { while ( !line.empty() ) { cout <<... (0 Replies)
Discussion started by: apenkov
0 Replies

4. Shell Programming and Scripting

I need to know how to replace a line after a pattern match with an empty line using SED

Hi How Are you? I am doing fine! I need to go now? I will see you tomorrow! Basically I need to replace the entire line containing "doing" with a blank line: I need to the following output: Hi How Are you? I need to go now? I will see you tomorrow! Thanks in advance.... (1 Reply)
Discussion started by: sags007_99
1 Replies

5. Shell Programming and Scripting

awk - remove row if specific field is empty/blank

I have this text.filecharles darwin sam delight george washington johnson culper darwin sam delight micheal jackson penny lite and would like to remove the row, if the first field is blank. so the result would be: result.filecharles darwin sam ... (4 Replies)
Discussion started by: charles33
4 Replies

6. Shell Programming and Scripting

How to erase junk Chars coming in only the first line

I have a file containing few thousands of lines. when I do cat on it , i find it having two special Chars at the start of first line alone as shown down here. ÿþHDR|20111024|01 If i delete this line and do a cat on file , the current first line is shown to have the same special Chars. ... (3 Replies)
Discussion started by: subramanian2008
3 Replies

7. UNIX for Dummies Questions & Answers

Erase line of text file one by one

Hi, I have a BASH script where I would like to identify all the lines of a text file that match specific pattern, and then erase them one by one. The ultimate goal will be to identify all the lines matching the pattern, and then for each line identified prompt the user whether or not to erase... (3 Replies)
Discussion started by: msb65
3 Replies

8. Shell Programming and Scripting

Fill the empty line by adding line before blank line

FIle A "A" 2 aa 34 3 ac 5 cd "B" 3 hu 67 4 fg 5 gy output shud be A"" 2 aa 34 "A" 3 ac 34 "A" 5 cd 34 "B" 3 hu 67 "B" 4 fg 67 "B" 5 gy 67 (6 Replies)
Discussion started by: cdfd123
6 Replies

9. Shell Programming and Scripting

howto add line as a first line into a non empty file

Hi Trying to do like this : echo "$variable1\n $(cat file.txt)" but it only adds one time. When I run this cmd again with different variable it only replaces line of variable1. How to add constantly line into first line in file ? (3 Replies)
Discussion started by: presul
3 Replies

10. Shell Programming and Scripting

How to erase files with line number less than 100

I am trying to delete all the files with line number less than 100 in a directory. Thank you. (5 Replies)
Discussion started by: Sean2008
5 Replies
Login or Register to Ask a Question