can some one help me write a macro or procedure to search for hostname column
should be stripped to read only hostname. there are other hostnames also in
there but they dont have the period. so i want to look for the ones with "."
and delete them

e.g CAIAP06D.nam.nsroot.net becomes CAIAP06D

Your help would be greatful. i dont know anything about writing a macro so
please help me in detail.

thanks in advance