Shell Programming and Scripting

Hi,

I'm trying to pick out a data field eg. from below. I need the required field as below but they are filled sometimes with weird chars like \-(. or watever. How can I accurately extract the 3rd field in shell?

ID IDNO - REQUIRED FIELD

ID 1447 - MAT620BR.
ID 1452 - FGI-LOM3100R \ LOM FGI REPORT (.
ID 1453 - FGI-LOM3101R \ LOM FGI REPORT (.
ID 1512 - SAM05TRR.
ID 1514 - SAM6220R.
ID 1515 - SAM07R.
ID 1516 - SAM07R00.
ID 1517 - SAM10R.
ID 1518 - SAM10R00.
ID 1521 - SAM13R.
ID 1536 - MONJ001R.
ID 1537 - MONJ004R.
ID 1541 - FROLPS.
ID 1542 - FROAPD.
ID 1548 - MOS5610R.
ID 1550 - C009LP \ DAILY INVOICE.
ID 1554 - SAM49R.
ID 1559 - MAT310AR.

You have various ways to extract lines from a text.

You could use head/tail

Code:

head -n 3 filename| tail -n 1

You can use sed

Code:

sed -n '3p' filename

You can use awk

Code:

awk 'NR == 3 {print}' filename

Etc...

To remove those chars, you can use tr

Code:

 redoubtable@Tsunami ~ $ awk 'NR == 3 {print}' filename|tr '.(\\' '\000'
ID 1453 - FGI-LOM3101R  LOM FGI REPORT 
redoubtable@Tsunami ~ $

Code:

awk -F"-" '{print $NF}' file

Can you show us what have you tried so far and where you are stuck?

Regards

Hi Ghost,



I was checking the recommendation you gave. But there was a problem.The output with your recommendation gave:



LOM3100R \ LOM FGI REPORT (.



The correct output should be:



FGI-LOM3100R \ LOM FGI REPORT (



without the fullstop but includes the FGI-



ID 1452 - FGI-LOM3100R \ LOM FGI REPORT (.

ID 1453 - FGI-LOM3101R \ LOM FGI REPORT (.

-----Post Update-----

Hi Franklin,

i've tried basic awk and cut to print 3rd field but they do not work. i used spaces and - as delimiters but they do not give the full output i require

Code:

awk -F" - " '{print $NF}' file

Are there better ways of making the extraction more accurate? it works with the " - " now, however, there could still be mistakes if a field would contain something like below.

FGI-LOM3100R - LOM FGI REPORT (.