DSXchange

source column is a decimal data type of (7,2).

Data in source :

123.34
3456.45
12.45
8.1

Question is: what is the funtion that I can use to extract the scale part of the decimal

as in source



123.34 --> 34
3456.45 --> 45
12.45 --> 45
8.1 --> 1

You can use any of the below functions to get the o/p :-

1) MantissaFromDecimal(<Column1>)
2) Field(<Column1>,'.',2)

Or even fieldname - Int(fieldname), multiplied by 10**x where x is the number of digits.

Thanks for the input. Closing the post as resolved.