translate a string into a number

acool · Post by **acool** » Mon Jun 21, 2004 5:00 pm

Hi everyone,

I need to convert a varchar into a numeric.
the varchar looks like this +xxxxx.xx , where x represents anumber.
for example, +00000.00, +00106.98, +00020.55

can anyone give me some ideas?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 21, 2004 5:07 pm

Because there are no data types within DataStage (OK, that's a simplification, but it's how things seem), you can actually do nothing.

If the sign is going to cause a problem, simply perform some arithmetic. The most efficient is adding zero.

Code: Select all

InLink.TheVarChar + 0