Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Delete rows in text file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Delete rows in text file
# 1  
Old 01-07-2011
Delete rows in text file
Hi
I do have a text file with 1000's of lines with 1 row and column with a specific pattern.
Code:
1102
1
1
1
1
1234
1
1
1
1
1009
1
1
1
1
1056
1
1
1
1
1098
1
1
1
1
1117

I want to clear all the rows containing the number '1' so that those row or lines are empty with out content.

Please Let me know the best way to edit it.
# 2  
Old 01-07-2011
Quote:
Originally Posted by Lucky Ali
...I do have a text file with 1000's of lines with 1 row and column with a specific pattern.
Code:
1102
1
1
1
1
1234
1
1
1
1
1009
1
1
1
1
1056
1
1
1
1
1098
1
1
1
1
1117

I want to clear all the rows containing the number '1' so that those row or lines are empty with out content.
...
Inline editing of the file using Perl -

Code:
$
$
$ cat f0
1102
1
1
1
1
1234
1
1
1
1
1009
1
1
1
1
1056
1
1
1
1
1098
1
1
1
1
1117
$
$
$ perl -pi.bak -e 's/^1\n$//' f0
$
$
$ cat f0
1102
1234
1009
1056
1098
1117
$
$

Sorry, did not read your question carefully. If you want to turn the lines that contain "1", blank, then -

Code:
$
$ perl -pi.bak -e 's/^1$//' f0
$
$
$ cat f0
1102
 
 
 

1234
 
 
 

1009
 
 
 

1056
 
 
 

1098
 
 
 

1117
$
$


tyler_durden
This User Gave Thanks to durden_tyler For This Post:
Lucky Ali
# 3  
Old 01-07-2011
I need to keep the space (4 rows) where the 1's were present as empty or blank spaces.
# 4  
Old 01-07-2011
Code:
sed 's/^1$//' inputFile

OR
Code:
awk '{if(0+$0 ==1) $0="";}1' inputFile

This User Gave Thanks to anurag.singh For This Post:
Lucky Ali
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to delete rows in a file

Hi All, I am new to UNIX . Please help me in writing code to delete all records from the file where all columns after cloumn 5 in file is either 0, #MI or NULL. Initial 5 columns are string e.g. "alsod" "1FEV2" "wjwroe" " wsse" "hd3" 1 2 34 #Mi "malasl" "wses" "trwwwe" " wsse" "hd3" 1 2 0... (4 Replies)
Discussion started by: alok2082
4 Replies

2. Shell Programming and Scripting

Delete rows from big file

Hi all, I have a big file (about 6 millions rows) and I have to delete same occurrences, stored in a small file (about 9000 rews). I have tried this: while read line do grep -v $line big_file > ok_file.tmp mv ok_file.tmp big_file done < small_file It works, but is very slow. How... (2 Replies)
Discussion started by: Tibbeche
2 Replies

3. UNIX for Dummies Questions & Answers

Delete all rows that contain a specific string (text)

Hi, I have a text file and I want to delete all rows that contain a particular string of characters. How do I go about doing that? Thanks! (9 Replies)
Discussion started by: evelibertine
9 Replies

4. 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

5. 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

6. Shell Programming and Scripting

[HELP] - Delete rows on a CSV file

Hello to all members, I am very new in unix stuff (shell scripting), but a want to learn a lot. I am a ex windows user but now i am absolutely Linux super user... :D So i am tryng to made a function to do this: I have two csv files only with numbers, the first one a have: 1 2 3 4 5... (6 Replies)
Discussion started by: Sadarrab
6 Replies

7. Shell Programming and Scripting

How to delete rows by RowNumber from a Large text file

Friends, I have text file with 700,000 rows. Once I load this file to our database via our cutom process, it logs the row number for rejected rows. How do I delete rows from a Large text file based on the Row Number? Thanks, Prashant (8 Replies)
Discussion started by: ppat7046
8 Replies

8. 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

9. 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

10. Shell Programming and Scripting

Delete repeated rows from a file

Hi everybody: Could anybody tell me how I can delete repeated rows from a file?, this is, for exemple I have a file like this: 0.490 958.73 281.85 6.67985 0.002481 0.490 954.833 283.991 8.73019 0.002471 0.590 950.504 286.241 6.61451 0.002461 0.690 939.323 286.112 6.16451 0.00246 0.790... (8 Replies)
Discussion started by: tonet
8 Replies
Login or Register to Ask a Question