[SOLVED] Text file column editing

crowzie · 07-17-2011, 06:33 AM

Hello guys
I have 2 large text files , one looks like this:

<contact type="1">blahblah@hotmail.com</contact>
<contact type="1">blahblah2@hotmail.com</contact>
<contact type="1">blahblah3@hotmail.com</contact>

The other is a list of emails in single column format like this:

emailaddy@hotmail.com
emailaddy2@hotmail.com
emailaddy3@hotmail.com , etc
Is there a command to delete all the blahblah emails from text file 1 and replace them with the ones from text file 2?

Or maybe a linux version of 'Csved' which has the ability to add,remove,insert columns?
Thanks in advance.

(Im sure seymour Berkoff from La femme Nikita uses linux!)

MTK358 · 07-17-2011, 06:51 AM

Quote:

Originally Posted by crowzie

Is there a command to delete all the blahblah emails from text file 1 and replace them with the ones from text file 2?

Replace them with what addresses from file 2?

druuna · 07-17-2011, 06:54 AM

Hi,

Assuming your examples are correct, why do you need to replace? Why not use the second file and place the tags around it:

Code:

$ cat infile2 
emailaddy@hotmail.com
emailaddy2@hotmail.com
emailaddy3@hotmail.com

$ sed 's%\(.*\)%<contact type="1">\1</contact>%' infile2
<contact type="1">emailaddy@hotmail.com</contact>
<contact type="1">emailaddy2@hotmail.com</contact>
<contact type="1">emailaddy3@hotmail.com</contact>

If this is what you want/need, you can let sed change in place by adding the -i flag:

Code:

sed -i 's%\(.*\)%<contact type="1">\1</contact>%' infile2

Hope this helps.

crowzie · 07-17-2011, 06:56 AM

There are 1000 emails in both text files.
I want to replace each email in file 1 with one from file two, It will be a perfect fit.

crowzie · 07-17-2011, 07:22 AM

Thanks druuna
You are the man!

druuna · 07-17-2011, 07:25 AM

You're welcome