VBScript to Remove Unwanted Dashes, Parentheses or Spaces From Phone Numbers


Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

TechKnowledge Content


Question:

In my source file, the column for phone number has dashes and parentheses. Sincethe phone number won't integrate correctly to Dynamics with them, how can I remove them?


Answer:
Use a VBScript to remove these unwanted characters. The complete script below uses the Replace function to replace any dash, parentheses or blank space with a null value, effectively removing it.


Dim PhoneStr

PhoneStr = SourceFields("Customers.Phone")

PhoneStr = Replace(PhoneStr,"-","")

PhoneStr = Replace(PhoneStr,"(","")

PhoneStr = Replace(PhoneStr,")","")

PhoneStr = Replace(PhoneStr," ","")

CurrentField = PhoneStr




This article was TechKnowledge Document ID:9714