want to remove last word.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting want to remove last word.
# 1  
Old 09-21-2011
want to remove last word.

Hi,

I have a file which has the following
Code:
 /u12/data/oracle/abc.dbf
/u12/data/oracle/def.dbf
/u12/data/oracle/daf.dbf
/u12/data/oracledb/fgh.dbf
/u12/data/oracledb/fkh.dbf
/u12/data/oracledb/kdq.dbf

I want to do something like this
Code:
  /u12/data/oracle
/u12/data/oracle
/u12/data/oracle
/u12/data/oracledb
/u12/data/oracledb
/u12/data/oracledb

I need to ignore the last word *.dbf
and use uniq command to find the mount point for checking space usage
Code:
df -m /u12/data/oracle
df -m /u12/data/oracledb

Thnx
Kaleem

Last edited by Scott; 09-22-2011 at 05:07 AM.. Reason: Use code tags, please...
# 2  
Old 09-21-2011
Code:
while read line; do
   dirname "$line"
done <INPUTFILE | sort -u | xargs df -m


Last edited by yazu; 09-21-2011 at 10:01 PM..
# 3  
Old 09-21-2011
Using awk:
Code:
$ awk ' /\/[^/]*.dbf$/ { sub("/[^/]*.dbf$","") ; A[$0]++ } 
END {for(dir in A) print "df -m " dir }' infile
df -m /u12/data/oracle
df -m /u12/data/oracledb

If your happy with the output you can use system() to run the df commands instead of print.
# 4  
Old 09-22-2011
Code:
$ nawk -F/ '{$NF= ""; print}' infile | sed 's, ,/,g;s,^,df -m ,g' | sh

# 5  
Old 09-22-2011
Code:
sed -e 's!/[^/]*$!!' infile | uniq | xargs df -m

# 6  
Old 09-22-2011
Code:
 
awk -F/ 'BEGIN{OFS="/"}{$NF="";print}' test | sort -u | xargs df -m

# 7  
Old 09-22-2011
Code:
awk -F/ '{NF--;a[$0]}END{for(i in a) print i}' OFS=/  file | xargs df -m

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to remove everything after a word containing string?

Hello, I wish to remove any word coming after searched string found in a word. source*.txt #!bin/bash #test1 http://www.aa.bb.cc http://www.xx.yy http://www.11.22.44 #test2 http://www.11.rr.cd http://www.01.yy http://www.yy.22.tt #test3 http://www.22.qq.fc http://www.0x.yy... (15 Replies)
Discussion started by: baris35
15 Replies

2. Post Here to Contact Site Administrators and Moderators

Please remove the word from posts

Hi Sir, Need your help in removing the following words from the posts . These are confidential info posted by mistake and our organization is doing an audit on this. Could you kindly remove as per below. https://www.unix.com/shell-programming-and-scripting/197017-perl-help.html ... (4 Replies)
Discussion started by: ptappeta
4 Replies

3. Shell Programming and Scripting

Remove word before a character

Hi, I have a file which looks like this id integer, name string, create_dt date, I want to remove all words that are present before the character , My output should be id, name, create_dt, Thanks wah (2 Replies)
Discussion started by: wahi80
2 Replies

4. Shell Programming and Scripting

Remove word with sed

How can I use sed or any utility to remove any word that begins with TRS-, I have tried sed 's/ERA.*//g' but seems not to be working Input: 23 TRS-458-9 345 235 45 TRS-42-5 423 000 76 300 234 Output: 23 345 235 45 423 000 76 300 234 (5 Replies)
Discussion started by: aydj
5 Replies

5. Shell Programming and Scripting

Remove last word of a string?

Hello I have a string that may or may not have 4 dots. The string is actualy a file within a folder, where multiple files are located. Files may look like: # ls * creds: 192.168.10.110 someserver shares: 192.168.10.110.Public someserver.sharefolder # I want to fill 2 variables,... (1 Reply)
Discussion started by: sea
1 Replies

6. Shell Programming and Scripting

How to remove first word?

Hi All, I want to remove the first word "cn=" from the below details. Only I want the number like 171345,174144... cn=171345 cn=174144 How can I achieve this. Please suggest. Thanks- P (6 Replies)
Discussion started by: pokhraj_d
6 Replies

7. Shell Programming and Scripting

Remove 1st word and _ from string

var=abc_cde_def_ghi_678.txt Expected output: cde_def_ghi_678.txt Is there a better way to achive this other than cut command? Basically, I need to remove the 1st word and _ from the string. Thanks. (1 Reply)
Discussion started by: vedanta
1 Replies

8. Shell Programming and Scripting

Remove particular word from file

Hi All, If my file is: Wed Sep 9 22:45:14 EDT 2009 sftp> sftp> sftp> sftp> sftp> sftp> sftp> sftp> sftp> sftp> sftp> sftp> sftp> This is log file generated from transfer... sftp> sftp> sftp> sftp> Files placed properly.... sftp> sftp> sftp> How can I remove "sftp>" word from this... (4 Replies)
Discussion started by: darshakraut
4 Replies

9. UNIX for Dummies Questions & Answers

using grep and to remove all word with uppercase

I try to write a small script that looks in the file tt for all the words that start with m in lowercase and in which there is no uppercase. #!/bin/sh grep ^m\.*\.\.* tt (4 Replies)
Discussion started by: cfg
4 Replies

10. Shell Programming and Scripting

how to remove first word

Hi, i have a question about to remove first word from a sentence. my script; #!/usr/bin/perl $msgtxt = "this is a test script"; my @ap_txtMsg = split(/ +/, trim_data($msgtxt)); $ap_msgtxt = splice (@ap_txtMsg, 0, 1); print $ap_msgtxt; but the output is first word that i... (1 Reply)
Discussion started by: malaysoul
1 Replies
Login or Register to Ask a Question