[Nerozwei]

I've got a problem with a light CMS driven site. I should change all emails in the content tables to the form first.name@organization.org. I think a good solution would be to run an emacs regexp on the dump.

The problem is I'm a novice with regexp. What is the right expression and how do I use it in Emacs?

[Paul McCann]

Umm, it might help if you let us know the format of the email addresses! That is, give us a sample email address: what it currently is and what you'd like it to be. Be as precise as you can and I'm sure someone will throw a regex based solution in your direction. (Not so sure it'll be for emacs though!)

Cheers,
Paul

[Nerozwei]

Originally posted by Paul McCann:
Umm, it might help if you let us know the format of the email addresses! That is, give us a sample email address: what it currently is and what you'd like it to be. Be as precise as you can and I'm sure someone will throw a regex based solution in your direction. (Not so sure it'll be for emacs though!)

Cheers,
Paul

Sorry about that. So the site now has mixed emails (using two different domains) like jane.doe@veterinary.org and john.doe@vet.org. All of these should be changed to firstname.lastname@vet.org (not jane.doe or john.doe, but firstname.lastname) to avoid email harvesters.

I've no idea on regexp syntax, but using traditional wildcards it would be something like this: *.*@*.org => firstname.lastname@vet.org

[Paul McCann]

OK, if I'm understanding you correctly, the following should make all the email addresses it trips across into the generic firstname.lastname@vet.org

Code:
perl -pi.bak -e 's/[a-z.]+\@[a-z.]+\.org/firstname.lastname\@vet.org/g' filename

where "filename" is the file containing your dump of email addresses (and possibly some other stuff, which will be left in tact). The original dump will be sitting in "filename.bak" after you execute the command.

Let us know if it doesn't work as expected.

Cheers,
Paul