Replace BLANKS with 0

[Sarath27]

Hi All,

Column Name - Count

Data Type - Int32

I want to replace BLANKS with '0'.

Please assist. Thanks

[niklas_greilinger]

Hello @Sarath27 ,

have you tried using the Data Cleansing Tool? This tool provides the option to replace Blanks with 0.

[binuacs]

@Sarath27 The int datatype cannot hold the blank values, if there is no data it can hold the NULL values. if you want to replace the NULL with 0 you can use the imputation tool

[Sarath27]

But in my case, its not null. Its only BLANKS. How can I change BLANKS to zero.

[binuacs]

@Sarath27 Can you check the datatype of that field? also, try the below formula

toNumber(Trim([Field]))

[Sarath27]

@Niklas I tried, but it didnt work.

[Sarath27]

@binuacs Pls refer this screenshot fort this issue and kindly assist me in this.

[binuacs]

@Sarath27 Seems that no records are coming through from your filter tools, Can you check the condition again and make sure that the records are satisfying the condition

[Sarath27]

Yes. For now there are no records satisfying the condition.

But for this case, zero records.

[binuacs · Accepted solution]

@Sarath27 If there are no records you cannot apply any formula. If the Data Type is an integer then a default 0 or NULL will be assigned to the field value, int will never allow blank values to that field, it will through an error.