How to delete last occurence of word using Linux command?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to delete last occurence of word using Linux command?
# 1  
Old 02-24-2013
How to delete last occurence of word using Linux command?

Hi all,
I am trying to delete last occurrence of word using sed command.
for example.
I have input like this
Code:
on a.id1 = b.id1 and
on a.id2 = b.id2 and
on a.id3 = b.id3 and

and I am expecting output like this
Code:
on a.id1 = b.id1 and
on a.id2 = b.id2 and
on a.id3 = b.id3

I just need to delete last occurrence of "and" from the last line only.

Thanks

Last edited by Scott; 02-24-2013 at 01:51 PM.. Reason: Code tags
# 2  
Old 02-24-2013
Pls use code tags as required by forum rules!

That's what I call a slack specification! For just removing that last "and", use
Code:
$ sed '$ s:and::' file
on a.id1 = b.id1 and
on a.id2 = b.id2 and
on a.id3 = b.id3

, but I assume there's more to come... e.g. remove the now trailing blank as well...
# 3  
Old 02-24-2013
Thanks for your quick reply RudiC.But this command is removing all "and"s from each line.
I am getting out put like this.
on a.id1 = b.id1
on a.id2 = b.id2
on a.id3 = b.id3

Thanks
# 4  
Old 02-24-2013
PLEASE use code tags for code and data as required by forum rules!

Did you issue the command as indicated? The $ sign is important!
As you can see, it worked for me, and it's standard sed.
# 5  
Old 02-24-2013
here is the command I am using.
echo $t| sed '$ s:and::'
here is the out from $t
on a.id1 = b.id1 and
on a.id2 = b.id2 and
on a.id3 = b.id3 and

Thanks
# 6  
Old 02-24-2013
PLEASE use code tags for code and data as required by forum rules!

Do I see a trailing empty line in the output of $t? The script is removing the "and" from that empty line.
# 7  
Old 02-24-2013
no trailing empty line in the output of $t
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Command to delete a word in all files

can anyone tell me what is the commands to delete the below particular word in the all files located in one particular file path files/ll>grep "/ftp/" test.kell ftp -m uskmc -d /ftp/ -i filename.zip output should be : ftp -m uskmc -d -i filename.zip (4 Replies)
Discussion started by: ramkumar15
4 Replies

2. Shell Programming and Scripting

How to find the number of occurence of particular word from a text file?

example: i have the following text file... i am very tired. i am busy i am hungry i have to find the number of occurence of a particular word 'am' from the text file.. can any one give the shell script for it (34 Replies)
Discussion started by: sheela
34 Replies

3. Shell Programming and Scripting

Delete all files if another files in the same directory has a matching occurence of a specific word

Hello, I have several files in a specific directory. A specific string in one file can occur in another files. If this string is in other files. Then all the files in which this string occured should be deleted and only 1 file should remain with the string. Example. file1 ShortName "Blue... (2 Replies)
Discussion started by: premier_de
2 Replies

4. Shell Programming and Scripting

Perl : Search for next occurence of a word in an array

I have an array as follows: Space: ABC Name: def Age: 22 Type: new Name: fgh Age: 34 Type: old Space: XYZ Name: pqr Age: 44 Type: new : : How can I separate the array with elements starting from Space:ABC until Space: XYZ & put them in a different array & so on... (4 Replies)
Discussion started by: deo_kaustubh
4 Replies

5. UNIX for Dummies Questions & Answers

counting the occurence of a word

In a file I have to count a particular word. like i need apache how many times. I tried this $ tr "\011" "\012\012"<foo1 | tr -cd "" |sort\uniq -c but I got result like this 32 apache 18 dns 12 doctor Please sugest me (4 Replies)
Discussion started by: pranabrana
4 Replies

6. Shell Programming and Scripting

finding the number of occurence of a word in a line

suppose i have this line abs|der|gt|dftnrk|dtre i want to count the number of "|" in this line.. how can i do that. plz help:confused: (9 Replies)
Discussion started by: priyanka3006
9 Replies

7. UNIX for Dummies Questions & Answers

search& count for the occurence of a word

Greetings, I need to search and count all the occurences of a word in all the files in a directory. Any suggestions greatly appreciated. Thanks (1 Reply)
Discussion started by: skoppana
1 Replies

8. Shell Programming and Scripting

Delete all occurence of a word in one shot

i have a file called file1 cat file1 i am namish namish lives in India India and namish both are good. I want to delete all the occurences of namish in one shot,if i do it with sed i guess all the lines will be deleted containing the pattern.Suggest me any idea without AWK. Thanks... (6 Replies)
Discussion started by: namishtiwari
6 Replies

9. Shell Programming and Scripting

Count the number of occurence of perticular word from file

I want to count the number of occurence of perticular word from one text file. Please tell me "less" command is work in ksh or not. If it is not working then instead of that which command will work. :confused: (40 Replies)
Discussion started by: rinku
40 Replies
Login or Register to Ask a Question