Page 1 of 1
String to Decimal Issue
Posted: Wed Jul 02, 2008 2:43 pm
by Shree0410
My input column is A - CHAR(9) with value of 000332422, My output should be 00.0332422.
I used a Decimal(9,7) for my output, but it writes 00.000000.
How do I resolve this?
Thanks, as always
Posted: Wed Jul 02, 2008 2:54 pm
by chulett
Divide the column by 10000000. Or use FMT to shift the decimal point over the correct number of places.
You marked this as a Server question so you got a Server answer.
Posted: Wed Jul 02, 2008 3:21 pm
by Shree0410
hmm..this should be parallel.
Can you tell me what it needs to get it done in parallel
Posted: Wed Jul 02, 2008 3:22 pm
by Shree0410
hmm..this should be parallel.
Can you tell me what it needs to get it done in parallel
Posted: Wed Jul 02, 2008 4:34 pm
by ray.wurlod
Code: Select all
StringToDecimal(Left(InLink.TheString,2) : "." : Right(InLink.TheString,7))
Posted: Thu Jul 03, 2008 9:38 am
by Shree0410
Thanks, much
Posted: Thu Jul 03, 2008 9:39 am
by Shree0410
Thanks, much