String to Number

dsdeveloper123 · Post by **dsdeveloper123** » Sun Jul 01, 2007 12:14 am

Hi all,

I have a string "-65".
In the transformer I want to do a mathematical operation on this string.
So I need to convert this string into number. How do I handle negative sign. Will DS function StringToDecimal work?
How do I accomplish this ?javascript:emoticon(':roll:')
Rolling Eyes

Thank u

ArndW · Post by **ArndW** » Sun Jul 01, 2007 1:54 am

Even though DS will do an implicit conversion from string to number in a transform stage, it is much better to explicitly convert using a function such as StringToDecimal(), which will take care of the sign.

dsdeveloper123 · Post by **dsdeveloper123** » Sun Jul 01, 2007 3:54 am

Thank ...

This partially solves my problem...
Actually the data coming in is "- 65" (there is space in between the negative sign and the number)
I tried Trim() but it doesn't work

dsdeveloper123 · Post by **dsdeveloper123** » Sun Jul 01, 2007 5:12 am

I got the Solution to my problem. I need to do StripWhiteSpace javascript:emoticon(':D')
Very Happy

ArndW · Post by **ArndW** » Sun Jul 01, 2007 5:17 am

Good job!

ray.wurlod · Post by **ray.wurlod** » Sun Jul 01, 2007 8:49 am

The overhead of invoking a JVM for every row is probably something you don't want. Prefer

Code: Select all

Convert(" ", "", InLink.TheNumericString)

If you're happy that you have a solution, please mark the thread as Resolved.

dsdeveloper123 · Post by **dsdeveloper123** » Sun Jul 01, 2007 9:11 pm

I tried convert.
The problem is if I have a decimal value, something like "- 65.70"
Convert(" ", "", InLink.TheNumericString) is giving me "-66" as the output but where as StripWhiteSpaces is giving me "-65.70"

ArndW · Post by **ArndW** » Sun Jul 01, 2007 10:16 pm

Convert() will not round, this is being done elsewhere. What is the defined datatype of the column or stage variable or derivation where you are doing thsi?