Question about sed

IceOner · 12-13-2007, 08:01 AM

Hello,

I have a question. Since I've never worked with sed, I thought you all could perhaps help me out with the following.

I have a file that will be read through line by line.
This file will be containing email addresses.
Example:

user@system.domain.com user@system.domain.com/
user2@system.domain.com user2@system.domain.com/

I'm looking for a sed command that will change the following.
The second email address line should be changed as follows:

user@system.domain.com system.domain.com/user/
user2@system.domain.com system.domain.com/user2/

Anyone that can help me sed this?
Thanks in advance

druuna · 12-13-2007, 08:46 AM

Hi,

You ask for a sed solution, but I think awk would be easier:

awk -F"[@ ]" '{ print $1"@"$2" "$2"/"$1"/" }' infile

It is possible in awk to set multiple field separators, the above command uses @ and a space a separator (-f"[@ ]").

Hope this helps.

matthewg42 · 12-13-2007, 08:47 AM

Provided the input is exactly as you described it (one space after first part, second address has trailing / character):

Code:

sed 's|\(^.*\) \(.*\)@\(.*\)|\1 \3\2|'

druuna · 12-13-2007, 08:49 AM

Hi,

@matthewg42: second field seems to be irrelevant, take a look at the second line (user2 vs user 1).

Which was changed by the OP while typing this......... which could also make my solution irrelevant.

matthewg42 · 12-13-2007, 09:01 AM

doh, you're quite right. I mean:

Code:

sed 's|^\(.*\)@\(.*\) \(.*\)@\(.*\)|\1@\2 \4\1|'

IceOner · 12-13-2007, 09:10 AM

Hey everyone,

Thanks for the help so far.
The user1 was my fault.

I've tried the awk option, and this is what came out:

test@test.com test test.com test/test/

Not exactly as I had in mind.
The input file contains the mailaddress twice, seperated by a tab.
The second time it is trailed by a slash.

test@test.com test@test.com/
test@test.test.com test@test.test.com/

And should change into:

test@test.com test.com/test/
test@test.test.com test.test.com/test/

Hope you get what I'm trying to get done.

Thanks for helping

colucix · 12-13-2007, 09:36 AM

Another awk solution

Code:

gawk -F"\t" '{split($2, array, "@"); print $1, array[2] array[1] "/"}' input_file

IceOner · 12-13-2007, 09:55 AM

Wow.. That is exactly what I was looking for!
Thanks so much, and I even get the gawk command this time..