Removing Quotation Marks from Null Value Outputs in a text file

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?

Output

Accepted answers

OTrieger

@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.

All comments

OTrieger

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.

2024-11-04_15-54-56.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703