Posted: Sun May 18, 2003 10:54 pm Post subject: Conversion Problem in MRM Contrl Centre
Voyager
Joined: 04 Mar 2003 Posts: 86
Question:
I have a element in MRM [Control Center] which is defined as STRING and taking in a data of fixed length 18.
I need to get the output as decimal with a precesion (14,2).
eg:
Input: 000000000046785000
Expected Output: 4678,5
So I need :
1. How can we get the desired output as mentioned above.
2. Do we have to change the DATATYPE of the element in the MRM.
3. Please provide the ESQL Code for the transformation.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum