I would like to delete all lines in a file that end with a 0 (zero).
I tried this:
Code:
sed '/0/d' file
but this deletes all the lines containing a zero, and I want to delete only those *ending* with a zero.
Then I tried
Code:
grep '0$' file
but that gives me as output only the last line.
How can I select that it chooses the pattern when it is *only* at the end of the line?
So I want my output to be all the lines not ending with a 0.
Moderator's Comments:
Please use CODE tags when displaying sample input and sample output as well as when displaying code segments.
Hi maya3,
One would expect that the command:
Code:
grep '0$' file
would print out all lines with a 0 at the end. Since that is not happening, we have to wonder what actually follows the 0 in the lines that are not being printed. Might this be a DOS format text file that has <carriage-return><newline> character pairs at the end of most lines instead of a UNIX format text file that just has a <newline> character at the end of each line? Please show us the output from the command:
Code:
head file | od -bc
where file is the name of the sample file you showed us in post #1 in this thread.
Note that grep '0$' file will give you the lines you want to delete (not the lines you want to keep) if file really does have lines with a trailing 0 character. To get the lines you want to keep, you probably want to use:
Code:
grep -v '0$' file > new_file
after we clean up whatever is keeping the lines with a 0 at the end of a line from being recognized.
I have a file with a few thousand lines and I'd like to remove all the lines that have more than 1 asterik (the * character) in it. So if it has 2 or more in a single line, I'd like the line removed (double d command in vi) (12 Replies)
I have a '~' delimited file of 6 - 7 million rows. Each row should contain 13 columns delimited by 12 ~'s. Where there are 13 tildes, the row needs to be removed. Each row contains alphanumeric data and occasionally a ~ ends up in a descriptive field and therefore acts as a delimiter, resulting... (7 Replies)
Hi,
I have a file that looks like this, the unity of information is composed of four lines, and these extends for millions.
My objective is to remove the highligthed "T".
How to attack this? This character is always constant in type "T" and position "1st" but the rest of the line is... (7 Replies)
Hi, I have one file, I need to check if file exist or not and then remove the lines which starts with ?
My file1.out data is some thing
abcabcppp
xyzxyzpqr
?????????
?????????
Output should be in test.out
abcabcppp
xyzxyzpqr
I am getting the output as below but the File does not exist... (4 Replies)
Hello,
I am working with a list that contains a large number of files listed by their absolute path. I am trying to determine a way to delete the file name at the end of each line, therefore leaving just the directory path. For example, I'd like to go from:
/home/something/file... (2 Replies)
Hi, I have multiple large files which consist of the below format:
I am trying to write an awk or sed script to remove all occurrences of the 00 record except the first and remove all of the 80 records except the last one.
Any help would be greatly appreciated. (10 Replies)
Hi,
I have numerous files which have data in the following format
A|B|123.|Mr.|45.66|33|zz
L|16.|33.45|AC.|45.
I want to remove decimal point only if it is last character in a number.
O/p should be
A|B|123|Mr.|45.66|33|zz
L|16|33.45|AC.|45
I tried this
sed -e 's/.|/|/g'
Problem... (6 Replies)
Hello,
Here is my text data excerpted from the webpage:
input
My target is to get:
What i tried is:
sed 's/.*\(connector\)/1/' input > output
but all characters coming before the word "connector" are deleted which is not good for me.
My question: (9 Replies)
Hi,
I came across one issue recently where output from one of the columns of the table from where i am creating input file has newline characters hence, record in the file is spread over multiple lines. Fields in the file are separated by pipe (|) delimiter. As header will never have newline... (4 Replies)
02-22-2019
