StringToDecimal

benny.lbs · Post by **benny.lbs** » Mon Sep 05, 2005 7:18 pm

I have a report in following format

12345678901234567890
--------------------
          23,030.12-

The negative sign is in the trailing position and there is comma inside the string, I would like to know what 's the best solution to convert this string into Decimal

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 05, 2005 8:27 pm

Assuming that the data type is a string of some kind, a buildop to remove the thousands delimiter(s), detect the sign and move it to the front of the string seems to be the way to go.

rumu · Post by **rumu** » Mon Sep 05, 2005 11:55 pm

ray.wurlod wrote:Assuming that the data type is a string of some kind, a buildop to remove the thousands delimiter(s), detect the sign and move it to the front of the string seems to be the way to go.

Hi,
I came across the same situation in my proj,wat i did exactly ruy suggest,moved the trailing -ve sign to prefix it ant trim ',' sign using stage varibles.

dsx_venkat · Post by **dsx_venkat** » Tue Sep 06, 2005 8:31 am

Even myself faced this problem, i choosed external routines (C routines)
and converted into parallel routines,