RemoveDecimal

Removes the decimal separator from a numeric value.

Syntax

RemoveDecimal( OriginalValue );

Parameters

Parameter Name Type Description Optional? Default Value
OriginalValue String OR Integer The numeric value containing a decimal separator. No n/a

Output

The original string with the decimal removed.

Use Case

The RemoveDecimal function will work differently depending on the type of decimal separator the original numeric value contains. If a period (.) is used, the function will remove before the separator and all numbers following it. For example, if the supplied value is the following:

19.99

Then the function will return this updated integer:

19

However, if the decimal separator is a comma (,) instead, the function will only remove the separator. Using the same input value as above, this would return the following integer:

1999