Write Null instead of Blank: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
End Function | End Function | ||
</syntaxhighlight> | </syntaxhighlight> | ||
If you would prefer that no value at all gets written to the destination field, check the "Skip Blank Writes" box under Manage Stages for that stage. | |||
Latest revision as of 16:31, 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
If you would prefer that no value at all gets written to the destination field, check the "Skip Blank Writes" box under Manage Stages for that stage.