How to replace all values in column to 0

Question

Below I have the sample dataset and I am wondering how do I replace all values to be 0's like my desired dataset? Thanks!

Sample:

6230176978977391103619

Result:

0000000000000000000000

flying008 · Answer

Hi, @overhead_press

If your field type is string, follow the below formula, if it is number, you need convert to string with tostring([Num])

NexBK · Answer

Hi, @overhead_press

If the data type is numeric, change to String, and use the Regex Tool to change all characters (.) to zero.

MarqueeCrew · Answer

@overhead_press  ,

if that's a string then:

replacechar([stuff],"123456789",'0')

should work

Cheers,

mark