Removing Quotation Marks from Null Value Outputs in a text file

[noelvarughese]

Hello,

I am trying to use Alteryx to read text files as inputs, reclassify and rearrange the data into new fields, and output the workflow as a tab delimited text file. There are some columns with null values, and I would like them to output as blank fields. However, I am currently getting an output of a blank string ("") for each of those values. Is there any way to output null values as blanks instead of a blank string?

[OTrieger · Accepted solution]

@noelvarughese 
Null in English has more than one meaning, however if you referring to 0 then you can replace all the blank cells with 0, you can do it with Cleanse tool or Multi Fields Formula tool, or formula tool.

[OllieClarke]

@noelvarughese what do you mean by blanks if not a blank string?

[CMichaelBNSF]

Try changing your "Quote Output Fields" option to "Never".  But be careful with this if your upstream data isn't super consistent.