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])
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |