cut but include delimiter at end


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting cut but include delimiter at end
# 1  
Old 12-14-2008
cut but include delimiter at end

Can someone please tell me how to do this...

input file - /etc/group:

Code:
wheel:*:0:root,timber
daemon:*:1:
mysql:*:88:
...etc...
giants:*:1001:dalton,bandit
dalton:*:1002:
bandit:*:1003:

output file (my goal):
Code:
giants:*:1001:
dalton:*:1002:
bandit:*:1003:

I've come up with this:

Quote:
egrep 'dalton|bandit' /etc/group | cut -sd':' -f1-3
which works fine, except the trailing colon is missing:

output file (missing trailing colon)
Code:
giants:*:1001
dalton:*:1002
bandit:*:1003

Is there a simple way to get the trailing colon appended, without invoking yet another script to do so?

Thank you in advance!
# 2  
Old 12-14-2008
With awk:

Code:
awk 'BEGIN{FS=OFS=":"}/dalton/||/bandit/{print $1,$2,$3 OFS}' /etc/group

Regards
# 3  
Old 12-14-2008
Code:
egrep 'dalton|bandit' /etc/group | cut -sd':' -f1-3 | sed 's/$/:/'

# 4  
Old 12-15-2008
Good old sed:

Code:
sed -n '/dalton\|bandit/{s/\(:[0-9]\{4\}:\).*$/\1/p}' /etc/group

HTH Chris
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Cut cmd with delimiter as |#|

Hi All- We have a file data as below with delimiter as |#| 10|#|20|#|ABC 13|#|23|#|PBC If I want to cut the 2nd field out of this, below command is not working as multiple pipe is causing an issue , it seems cut -f2 -d"|#|" <file_name> can you please help to provide the correct command... (7 Replies)
Discussion started by: sureshg_sampat
7 Replies

2. Shell Programming and Scripting

cut delimiter and save

i have list of names in a text file and I wanted to delete the commas en every line. for example: inside the text is a list of names in it with commas after each line. I wanted to delete these commas. which command must I execute for this? unix, dale, shawn, aaron, (4 Replies)
Discussion started by: garfish
4 Replies

3. Shell Programming and Scripting

sed should cut of everything include the brackets

Hi there! sed should cut of everything include the brackets ... 443,0.806362,0.67317,1.46563,14.8237(#/cm�) ... 5112,0.812411,0.67317,1.4831,14.1875(#/cm�) it should be ... 443,0.806362,0.67317,1.46563,14.8237 ... 5112,0.812411,0.67317,1.4831,14.1875 i try it several times with ...... (4 Replies)
Discussion started by: IMPe
4 Replies

4. Shell Programming and Scripting

How to cut by delimiter, and delimiter can be anything except numbers?

Hi all, I have a number of strings like below: //mnt/autocor/43°13'(33")W/ and i'm trying to get the numbers in this string, for example 431333 please help thanks ahead (14 Replies)
Discussion started by: sunnydanniel
14 Replies

5. Shell Programming and Scripting

Cut columns with delimiter

HI, I have a file like below "103865","103835","Zming","","Zhu","103965","Sunnyvale","US", "116228","116227","Morlla","","Kowalski","113228","Paese "(Treviso)""IT" I want to validate the 7th column which is below. "Sunnyvale" "Paese In the above 7th column Paese is not ended with... (9 Replies)
Discussion started by: Krrishv
9 Replies

6. Shell Programming and Scripting

cut -d with more than 1 delimiter?

I need to cut or otherwise get the 4th and 5th position output of for i in `date +%H` ; do vnstat --dumpdb | grep "h;$i" ; done example output is: h;13;1310318701;443;93 I only need ";443;93" from any given run of "for i in `date +%H` ; do vnstat --dumpdb | grep "h;$i" ; done" Thanks... (3 Replies)
Discussion started by: Habitual
3 Replies

7. UNIX for Advanced & Expert Users

use a word as a delimiter with cut

Is there a way to use a word as a delimiter with cut? Or is there a way to use sed or awk with a word as a delimiter? I don't care which program I use for a delimiter I just want to use a word as a delimiter. (2 Replies)
Discussion started by: cokedude
2 Replies

8. Shell Programming and Scripting

Include white spaces while using CUT command

Hi I tried to extract 19 characters (default) enclosed with in tag from a file using cut command. If the characters comprises of double space, the cut command gives the output with a single spacing. file 1 <name>Kumar Rajasekaran</name> cut -c7-26 "file1" the out put i received is ... (48 Replies)
Discussion started by: Sekar1
48 Replies

9. Shell Programming and Scripting

Cut Number which appear before a delimiter

Hi All, How can i use the cut option to only output the number of rows, which is 2 is this case ? Pls note that the number of digit before the delimiter ":" is always varying. $ grep -n uuu xxx 2:** xxx yyy gg 44 tt uuu 2007 $ (2 Replies)
Discussion started by: Raynon
2 Replies

10. Shell Programming and Scripting

\r as delimiter in cut

I need to use \r as a delimiter in the -d option of the cut comand . Any help ? Thanks in advance . SD (5 Replies)
Discussion started by: shweta_d
5 Replies
Login or Register to Ask a Question