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
convert from decimal to string
Moderators: chulett, rschirm, roy
-
rockunder78
- Participant
- Posts: 8
- Joined: Mon Jun 18, 2007 11:08 pm
- Location: chennai
Re: convert from decimal to string
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]
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]
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: