J
Jim Kiddoo
Hello,
I am trying to import a Global address list, but my problem is I need just
the smtp address in the cell so i want to strip out all the other junk, here
is a couple of examples of what the field could appear like. I need to strip
out everything accept for the SMTP:[email protected]. It
could be any extension and it is not always a percent at the beginning or
end.
SMTP:[email protected]%MS:UOF9/UNIVERSITY/bcairn%X400:c=US;a=;p=Uof9;o=Univ
ersity?Hall;s=Cairn;g=bubba;%CCMAIL:Cairn, bubba at University_Hall
CCMAIL:ssdsexam at
STUDENT-SERV%MS:UOF9/STUDENTSER/SSDSEXAM%SMTP:[email protected]%X4
00:c=US;a= ;p=Uof9;o=STUDENT-SERV;s=ssdsexam;
Any help is much appreciated.
Sincerely
Jim Kiddoo
I am trying to import a Global address list, but my problem is I need just
the smtp address in the cell so i want to strip out all the other junk, here
is a couple of examples of what the field could appear like. I need to strip
out everything accept for the SMTP:[email protected]. It
could be any extension and it is not always a percent at the beginning or
end.
SMTP:[email protected]%MS:UOF9/UNIVERSITY/bcairn%X400:c=US;a=;p=Uof9;o=Univ
ersity?Hall;s=Cairn;g=bubba;%CCMAIL:Cairn, bubba at University_Hall
CCMAIL:ssdsexam at
STUDENT-SERV%MS:UOF9/STUDENTSER/SSDSEXAM%SMTP:[email protected]%X4
00:c=US;a= ;p=Uof9;o=STUDENT-SERV;s=ssdsexam;
Any help is much appreciated.
Sincerely
Jim Kiddoo