Page 1 of 1
convert from decimal to string
Posted: Fri Jun 20, 2008 4:05 am
by rockunder78
how to use type conversion function? wht will be the syntax
decimal to string:DecimalToString(%number%,[%"[fix_zero][,suppress_zero]"%])
10.22 to convert into 1022
Re: convert from decimal to string
Posted: Fri Jun 20, 2008 5:43 am
by vkhandel
You can achieve the result by using the following stage variables -
decimaltostring(<column_name>,"suppress_zero") ............. SVar1
Index(SVar1, ".",1) ............. SVar2
Len(SVar1) - SVar2 ............ SVar3
And then writing the following derivation -
SVar1[1,(SVar2- 1)] : SVar1[(SVar2+ 1),SVar3]
Posted: Fri Jun 20, 2008 7:20 am
by ray.wurlod
Multiply by 100?