Starfish ETL | Sample Global VB Script Functions

Sample Global VB Script Functions
Clean String Functions - Remove Unwanted Characters
Source: http://www.code-tips.com/2009/04/vbscript-string-clean-function-remove.html Specify specific characters to remove or replace Function strClean (strtoclean) Dim objRegExp, outputStr Set objRegExp = New Regexp objRegExp.IgnoreCase = True ...
Format Phone Number
Here are a couple of sample functions to help you clean up phone numbers. Function ScriptedField dim oldphone dim phone dim xPos dim plusPos dim extension oldphone="@@ORG:phone_office@@" phone=oldphone if len(phone) <> 0 then 'Remove all non-numberic ...

Starfish ETL | Sample Global VB Script Functions | Knowledge Base