Convert Null to 0 on Export

[Clint]

I'm asking to hopefully save time later.  (Note that I don't need this for application functionality - just for a final downloaded file.)

I need to end up with an excel file that has no null fields - they need to be converted to "0". Is it possible to download a table as a csv/xls file and convert simultaneously? Or have that happen during a scheduled task export?

Any tips would be greatly appreciated.

Thanks!

[Clint]

Well - I realized I can use Excel's "Find and Replace" feature to accomplish this in essentially a couple clicks. 

If there's a simple Caspio solution - I'm all game to check it out. Otherwise, Find and Replace works.

Clint

[MayMusic]

Easiest and safest is doing it in excel and then import the file. you can also try REPLACE option in table section but I am afraid it replace spaces with 0 as well