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:
| 6230 |
| 17697 |
| 8977 |
| 3911 |
| 03619 |
Result:
| 0000 |
| 00000 |
| 0000 |
| 0000 |
| 00000 |
if that's a string then:
replacechar([stuff],"123456789",'0')
should work
Cheers,
mark
Hi, @overhead_press
If the data type is numeric, change to String, and use the Regex Tool to change all characters (.) to zero.
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])

