Sponsored Content
Full Discussion: Delete rows in text file
Top Forums Shell Programming and Scripting Delete rows in text file Post 302486234 by durden_tyler on Friday 7th of January 2011 12:57:12 PM
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:
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

10. 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
GETUNIMAP(8)							       Linux							      GETUNIMAP(8)

NAME
getunimap - dump the unicode map for the current console to stdout SYNOPSIS
getunimap [ -s ] [ -C console ] DESCRIPTION
The getunimap program is old and obsolete. It is now part of setfont (1). The getunimap program outputs the unicode map (also called a "Screen Font Map") for the current console to standard output. The -C option may be used with Linux 2.6.1 and later to get the map for a console different from the current one. Its argument is a path- name. The output of getunimap is of the form 0xAA U+1234 # comment where 0xAA is the font character code and U+1234 is a unicode character, that if displayed, will be displayed using glyph 0xAA in the font. Many unicode characters may be mapped to the same glyph. the Hash symbol # is used as a comment delimiter; characters after a hash sign (to the end of the line) are comments. The -s option will sort and merge elements, sorting on font character. Hence, it will produce output of the form: 0x22 U+1234 U+5678 U+3456 0x23 U+0023 etc., listing the multiple unicode characters that map to a font glyph. The output of getunimap is of the form accepted by setfont and psfaddtable SEE ALSO
psfaddtable(1), setfont(1). Console Tools 2004-01-01 GETUNIMAP(8)
All times are GMT -4. The time now is 08:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy