Visit Our UNIX and Linux User Community


extract last word on line to new file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers extract last word on line to new file
# 1  
Old 05-02-2002
Question extract last word on line to new file

Can someone please help me with how to extract the last word on a line to a new file? I have a list of names like:

Ms. Nell D. Bullock
Mrs. Sherrie M Avent
LINDA ANNETTE RUSSELL
Mr. Jerome R. Harris
Pandora Tyndall

I want the new file to look like this:
Bullock
Avent
RUSSELL
Harris
Tyndall

Thanks for any help.
# 2  
Old 05-02-2002
Try:
sed 's/[a-zA-Z]* //g' < inputfile
# 3  
Old 05-02-2002
The filename is names: I tried.
sed 's/[a-zA-Z]* //g' < names

and got:

D.Bullock
Ham
Mrs.Avent
RUSSELL
Mr.R.Harris
Tyndall
Ms.D.Alamo

Not exactly... but I think I can fiddle with it from here.
What does //g do in the command above?
# 4  
Old 05-02-2002
I got it...! I needed to remove the dots/periods first.
How could I have done this in one command?

sed 's/[.]//g' < names > names3
sed 's/[a-zA-Z]* //g' < names3 >names4
# 5  
Old 05-02-2002
Dang! I forgot about the periods. Try:

sed 's/[.a-zA-Z]* //g' < inputfile
# 6  
Old 05-02-2002
Thanks so much!
# 7  
Old 05-02-2002
awk is cooollll!!!!!! :D

Another handy way to get the last field per line in a file is to use awk.


awk '{ print $NF }' < filename > newfile

or

awk '{ print $1, $NF }' < filename > newfile

This will print field one and the last field as well.



Smilie
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #394
Difficulty: Medium
POSIX mandates 1024-byte default block sizes for the df and du utilities, reflecting the typical size of blocks on disks.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to extract the word after a particular keyword throughout the file..

Hi Everyone, Need help in extracting the hostname from the below output. Expected output: DS-TESTB-GDS-1.TEST.ABC.COM DS-TESTB-GDS-2.TEST.ABC.COM .... ... /tmp $ cat -n /tmp/patchreport 1 /usr/bin/perl /admin/bin/patch/applyPatches.pl --apply_patches... (4 Replies)
Discussion started by: thiyagoo
4 Replies

2. Shell Programming and Scripting

Extract the word from the file and print it

I have a file which I am reading and then I need to extract a particualr word and if it matches the line. 2015-01-22 07:30:17,814000 +0900 /INFO: - <ns2:virtualServerid="PH11PK" /> Means if the line contain Virtual server I need to extract the id . Code I wrote#!/usr/bin/perl ... (19 Replies)
Discussion started by: karan8810
19 Replies

3. Shell Programming and Scripting

Read a File line by line and split into array word by word

Hi All, Hope you guys had a wonderful weekend I have a scenario where in which I have to read a file line by line and check for few words before redirecting to a file I have searched the forum but,either those answers dint work (perhaps because of my wrong under standing of how IFS... (6 Replies)
Discussion started by: Kingcobra
6 Replies

4. Shell Programming and Scripting

extract a word from text file name

Hi i want to extract the word present before .txt in the text file. For example, Sample_ab_a.txt ----------> i need 'a' Sample_abc_b.txt -----------> i need 'b' Can anyone help me in getting the word extracted (5 Replies)
Discussion started by: Sindhuap
5 Replies

5. UNIX for Dummies Questions & Answers

Need to extract the 2nd last word of each line

Hello experts, I have question that i want to extract the second last word of each line. I have a text file, in that text file there are near about 40 lines. sample of line present in file /user/Oracle/x/x/S/part_bkp/temp_part_bkp/x1/test1... (2 Replies)
Discussion started by: aks_1902
2 Replies

6. Shell Programming and Scripting

Extract word from a line

Hi, I've searched the forum to get what I wanted but to no avail. Here's the problem I'm facing. The line is suppose as below: <INPUT DATABASE ="ORACLE" DBNAME ="UNIX" NAME ="FACT_TABLE" OWNERNAME ="DIPS"> Now I want to extract only FACT_TABLE. The trials are as follows: awk... (3 Replies)
Discussion started by: dips_ag
3 Replies

7. Shell Programming and Scripting

get the fifth line of a text file into a shell script and trim the line to extract a WORD

FOLKS , i have a text file that is generated automatically of an another korn shell script, i want to bring in the fifth line of the text file in to my korn shell script and look for a particular word in the line . Can you all share some thoughts on this one. thanks... Venu (3 Replies)
Discussion started by: venu
3 Replies

8. Shell Programming and Scripting

How to extract just a word from a File in Shell?

Hello Friends, I have a txt file which has data like this TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 23-MAR-2010 15:38:42 Copyright (c) 1997, 2006, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to... (7 Replies)
Discussion started by: njafri
7 Replies

9. UNIX for Dummies Questions & Answers

Word extract from a line

In a file let a.txt, has 1 line code i.e. code QC:Tiger:10: /code I need to get my output like "Tiger 10". So how can i do this? (3 Replies)
Discussion started by: anupdas
3 Replies

10. Shell Programming and Scripting

Can a shell script pull the first word (or nth word) off each line of a text file?

Greetings. I am struggling with a shell script to make my life simpler, with a number of practical ways in which it could be used. I want to take a standard text file, and pull the 'n'th word from each line such as the first word from a text file. I'm struggling to see how each line can be... (5 Replies)
Discussion started by: tricky
5 Replies

Featured Tech Videos