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 edit summary
Line 3: Line 3:
<syntaxhighlight lang="vb">
<syntaxhighlight lang="vb">
Function ScriptedField
Function ScriptedField
ScriptedField = "@@ORG:law_firm_c@@"
  ScriptedField = "@@ORG:law_firm_c@@"
if len(ScriptedField) = 0 then
  if len(ScriptedField) = 0 then
  ScriptedField = vbNullChar
    ScriptedField = vbNullChar
end if
  end if
End Function
End Function
</syntaxhighlight>
</syntaxhighlight>

Revision as of 16:28, 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