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

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