UNIX for Dummies Questions & Answers

The column went away with my awk example. Not correct or want an awk-less solution?


Yes, as Peasant said, with sed

Code:

sed 's/root@####://g' file > outfile

Well the sed command won't work, because like I originally said, the part (root@####) is different on many lines. The #### is just a label for multiple different servers, like server1, server 3.

There is like 15 of them. I don't wan't to type in the sed command for every different root@server1, root@server2, root@server3, etc.

Do you see what I'm saying?

About the awk part, it works, I just have to trim the part of the lines containing server names delimited by colon.

Here is the file with servers listed, maybe that will help with the visual:

Does that make more sense. I know I'm confusing people, but see how there are different servers being listed and that the bottom part of the file has one more column delimited by a colon.

I would have to use separate sed commands, unless there is a way to delimit that part and erase it from every line.

But the awk version took care of the extra column, because it just uses ':' as delimiter and prints the last 2 columns...

Code:

mute@geek:~/test$ awk -F: 'NF > 2 { print $(NF-1) $NF }' sync.txt
 /opt/sysadm/bin/nbu_unassign_media.sh need to install
 /opt/sysadm/lib/rtidirs.dist.20110131 need to install
 /opt/dba/bin/goe need to update
 /opt/dba/bin/removedbaccount.sh need to update
 /opt/dba/results/res03000.r need to remove
 /opt/dba/results/res03001.r need to remove
 /opt/dba/results/res03099.r need to remove

...?

It's giving me an error on the sync.txt file:

Code:

awk: Cannot find or open file sync.txt.
 The source line number is 1.

It means what it says. You don't have sync.txt

Replace it with your own filename, or leave the filename off completely and just pipe something into it.

If you're telling vi to use it as a filter, I suppose you'd just leave it off.

Nice...that did it. Thanks guys....

This sed should fill your requirment i believe.

Code:

sed 's/root@\(server[0-9]\{1,4\}: \)\|\(server[0-9]\{1,4\}: \)//g' input > output