Deleting decimals from a number

[Cfdiaz2103]

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.

[gautiergodard]

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.

[Luke_C · Accepted solution]

Hi @Cfdiaz2103 

Try the floor() function

[Sebastiaandb]

@Cfdiaz2103 @gautiergodard 

Select tool and change type to Int32 does it :-)

[DataNath]

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.