Convert Fixed Decimal to String or Extract all digits before decimal

[hash_89]

I am trying to extract the all digits before decimal point from a fixed decimal column.

For eg, if the number is 132345.00000 , I need to extract "132345". How can I achieve this?

[MelGibson]

 This should resolve your issue.  Floor will remove the decimal part of the number, which leaves you with an integer.  

TONUMBER(FLOOR([YourColumnName])) IF YOUR INCOMING FIELD IS A NUMBER

TOSTRING(FLOOR([YourColumnName])) IF YOUR INCOMING FIELD IS A STRING

[nagakavyasri]

@hash_89 You can also find the position of decimal point 1st and consider the numbers on left: