Scripting: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
No edit summary
Line 3: Line 3:
*[[Execute When]]
*[[Execute When]]


=VBScript Resources=
=VBScript=
==VBScript Resources==
*http://www.w3schools.com/asp/vbscript_ref_functions.asp
*http://www.w3schools.com/asp/vbscript_ref_functions.asp
*VBScript Constants, like vbCrLf, etc: http://powerasp.net/content/new/vbscript-constants.asp


=Sample Global VB Script Functions=
==Sample Global VB Script Functions==
*[[Format Phone Number]]
*[[Format Phone Number]]


=Field Scripting Examples=
==Field Scripting Examples==
*[[Convert state abbreviations to full name with VBScript]]
*[[Convert state abbreviations to full name with VBScript]]
*[[Parse text and look up ID based on result]]
*[[Parse text and look up ID based on result]]
*[[Write Null instead of Blank]]
*[[Write Null instead of Blank]]


=Job Scripting Examples=
==Job Scripting Examples=
*[[Check for duplicates using xref]]
*[[Check for duplicates using= xref]]
*[[Interact with the local file system]]
*[[Interact with the local file system]]
*[[Pull data from a source and write to file]]
*[[Pull data from a source and write to file]]
*[[Retrieve Records Modified After Last Run DateTime]]
*[[Retrieve Records Modified After Last Run DateTime]]
*[[Use Before Save and After Save operations to loop through a single origin record multiple times]]
*[[Use Before Save and After Save operations to loop through a single origin record multiple times]]

Revision as of 01:23, 14 September 2015