Write Null instead of Blank

Write Null instead of Blank

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.


Another option is to use a special code, @@CHR:DBNULL@@, which will force the writing of a NULL to the destination. You can use this in scripts or as a hardcoded value as illustrated below: