String to Decimal Issue

Shree0410 · Post by **Shree0410** » Wed Jul 02, 2008 2:43 pm

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

chulett · Post by **chulett** » Wed Jul 02, 2008 2:54 pm

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.

Shree0410 · Post by **Shree0410** » Wed Jul 02, 2008 3:21 pm

hmm..this should be parallel.

Can you tell me what it needs to get it done in parallel

Shree0410 · Post by **Shree0410** » Wed Jul 02, 2008 3:22 pm

hmm..this should be parallel.

Can you tell me what it needs to get it done in parallel

ray.wurlod · Post by **ray.wurlod** » Wed Jul 02, 2008 4:34 pm

Code: Select all

StringToDecimal(Left(InLink.TheString,2) : "." : Right(InLink.TheString,7))

Shree0410 · Post by **Shree0410** » Thu Jul 03, 2008 9:38 am

Thanks, much

Shree0410 · Post by **Shree0410** » Thu Jul 03, 2008 9:39 am

Thanks, much