Frank,

Thanks for the input. I actually think I have it figured out. I am doing something similar to what you are suggesting. In my destination system I have a countries table where I am storing the international prefix and the countty code. I have added another Source and I am using a Merge Join to get it all into 1 dataset. Then in a script component I am removing all the non-numeric characters and stripping the extension when it exists. Then I just have the "clean" phone number. Then I do a compare on the country code like this:

If strPhone <> String.Empty Then

strCode = strPhone.Substring(0, CodeLength)

If strCode = Code Then

strPhone = Phone.Substring(CodeLength)

End If

End If

And yes, I do need the check for empty string as there are some phone numbers that, once purged of non-numeric characters are empty.

I'll post how the final results turn out.

As you said the cleanup is tricky because the source system did absolutely no checking for phone number validity. I had names, email addresses, and other "data" in the phone number:hehe: