Decimal

manikumar · Post by **manikumar** » Thu Aug 05, 2010 1:30 am

Hi,

i have an input seq file
i have input like this

column1
----------
2.49558695
6.766
9.18347580
3.495
2.494020

the column datatype is decimal

the out put like this
column1
--------
.495
.766
.183
.495
.494

Sreenivasulu · Post by **Sreenivasulu** » Thu Aug 05, 2010 1:33 am

Conver to 'varchar' and use field+Right function to get 3 digits after the decimal position

Regards
Sreeni

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 05, 2010 1:49 am

Try something like

Code: Select all

yourField - Int(yourField)

ray.wurlod · Post by **ray.wurlod** » Thu Aug 05, 2010 1:54 am

DecimalToDecimal() where the target has a scale of 3 ?