Hi guys,
Is it possible to delete decimals from every number of a specific field?
Here's a look of a sample of the data I currently have:
Input
12373.54
3127391.5
123.43
63232.7
12335
1235576.89
1230044.00
1265654.54
and here's the desired output:
Output
12373
3127391
123
63232
12335
1235576
1230044
1265654
As you can see, there's no an existing rounding process for each number. It´s simply trimming their corresponding decimals.
I'd appreciate any kind of support.
Solved! Go to Solution.
Hello @Cfdiaz2103
Changing the data type to an integer should do the trick.
You can do this using a select tool, and select Type = Int16 for example.
The Integer solutions offered won't work as they'll apply rounding during the conversion which you said you don't want/need. Best and simplest solution here is to go with the floor() function as mentioned by @Luke_C.