Write Null instead of Blank: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(Created page with "By default, Starfish will write a blank, "", value to the destination. If you instead want to write Null, you must use a script for this. <syntaxhighlight lang="vb"> Functio...")
(No difference)

Revision as of 16:27, 30 March 2015

By default, Starfish will write a blank, "", value to the destination. If you instead want to write Null, you must use a script for this.

Function ScriptedField
 ScriptedField = "@@ORG:law_firm_c@@"
 if len(ScriptedField) = 0 then
  ScriptedField = vbNullChar
 end if
End Function