Write Null instead of Blank

From Starfish ETL
Revision as of 16:27, 30 March 2015 by Jkuehlthau (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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
Retrieved from "https://wiki.starfishetl.com/index.php?title=Write_Null_instead_of_Blank&oldid=4721"