Shell Programming and Scripting

I'm looking for an awk or (preferably) sed solution to search a pipe delimited file for any occurrence of an email address that does not include a designed domain, and replace the email address with a blank. E.g.

hello|smith@designateddomain.com|jones@anotherdomain.edu|1234|

turns into:

hello|smith@designateddomain.com||1234|

Starting of with a /@/ { would probably be safe I think, given the nature of the data. Some sample/starter code showing the conditional logic (and whatever else you have the patience to include) would be appreciated.

Thanks in advance!

Try:

Code:

awk -F"|" -vOFS="|" '{for (i=1;i<=NF;i++) if ($i~"@" && $i!~"@designateddomain.com") $i=""}1' infile > outfile

Thanks... This one is an eye opener for me!