Handling nulls in a blob field

Question

I'm using a blob field to sftp a pipe delimited file to a server. When the file outputs, the null fields have been removed. I'm wanting to output all fields so that the header corresponds appropriately to the column.

example output:

ACCOUNT_NUMBER|PREFIX|FIRST_NAME|LAST_NAME

123|HILARY|LESTER

234|MRS.|TARA|JONES

desired output (add extra | in first row of data):

ACCOUNT_NUMBER|PREFIX|FIRST_NAME|LAST_NAME

123||HILARY|LESTER

234|MRS.|TARA|JONES

danrh · Accepted Answer

Hey @hilarylester, try replacing the nulls with empty strings.  Either use the Data Cleansing tool, or a formula something like:

IF IsNull([Value]) THEN '' ELSE [Value] ENDIF

If this doesn't fix the issue, can you share the process of how you're outputting?