sed or other tool to manipulate data, including email addresses

manouche · #1 (**permalink**) 02-19-2008

I have a list of names and email addresses, like this. The <tab> markers are actually tabs.

joe.blow <tab> joe.blow@wherever.com
tom.t.hall <tab> tom.t.hall@wherever.com
john.r.smith <tab> john.r.smith@wherever.com
sally.jones <tab> sally.jones@state.or.us

I want to parse the data so that it will result in this:

joe <tab> blow <tab> joe.blow@wherever.com
tom <tab> hall<tab> tom.t.hall@wherever.com
john <tab> smith <tab> john.r.smith@wherever.com
sally <tab> jones <tab> sally.jones@state.or.us

So, all I need to do is remove the dot, if present, in the first part of each line. The second part (the email address) goes untouched.

So, I can easily use sed to go through and replace a 'character dot character', since sed looks for the first occurrence on each line, like this:

sed 's/\.[a-z]\./ /' emailfile.txt

That results in this:

joe.blow <tab> joe.blow@wherever.com
tom <tab> hall <tab> tom.t.hall@wherever.com
john <tab> smith <tab> john.r.smith@wherever.com
sally.jones <tab> sally.jones@state.or.us

If I run that sed command again, it will modify the email part (character.dot.character).

How can I get the result I need? Is sed the best tool for this?

jim mcnamara · #2 (**permalink**) 02-19-2008

awk?

Quote:

$ > cat file
joe.blow joe.blow@wherever.com
tom.t.hall tom.t.hall@wherever.com
john.r.smith john.r.smith@wherever.com
sally.jones sally.jones@state.or.us

$> t.awk
joe blow joe.blow@wherever.com
tom t hall tom.t.hall@wherever.com
john r smith john.r.smith@wherever.com
sally jones sally.jones@state.or.us
$ >

Code:

awk -F'\t' '{ 
    split( $1,arr, ".")
    for(i=1; arr[i]>""; i++) {printf("%s\t",arr[i])}
    print $2
             } ' file

ynixon · #3 (**permalink**) 02-19-2008

try this

Code:

sed 's/\.[[:alpha:]]\.\(.*\)$/ \1#/;/#/!s/\.\(.*\)$/ \1/;s/#$//' emailfile.txt

ynixon · #4 (**permalink**) 02-19-2008

Quote:

Originally Posted by jim mcnamara

awk?

Code:

awk -F'\t' '{ 
    split( $1,arr, ".")
    for(i=1; arr[i]>""; i++) {printf("%s\t",arr[i])}
    print $2
             } ' file

this is the right syntax for awk:

Code:

awk -F'\t' '{
   split( $1,arr, ".")
   if ( 3 in arr ) 
      { printf("%s %s\t",arr[1],arr[3]) } 
   else 
      { printf("%s %s\t",arr[1],arr[2]) }  
   print $2
            } ' emailfile.txt

since the given output is exactly as requested

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Email Question - two email addresses	jyoung	Shell Programming and Scripting	5	08-04-2008 01:00 PM
manipulate data with specific format	tonet	Shell Programming and Scripting	5	04-25-2008 11:24 AM
email addresses	okbrowder	UNIX and Linux Applications	0	04-20-2008 03:02 PM
How to delete old email addresses?	Deede	UNIX for Dummies Questions & Answers	1	02-03-2004 04:25 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by