Write Null instead of Blank: Difference between revisions
Jump to navigation
Jump to search
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...") |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 3: | Line 3: | ||
<syntaxhighlight lang="vb"> | <syntaxhighlight lang="vb"> | ||
Function ScriptedField | Function ScriptedField | ||
ScriptedField = "@@ORG:law_firm_c@@" | |||
if len(ScriptedField) = 0 then | |||
ScriptedField = vbNullChar | |||
end if | |||
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.