Is there a function to convert a string into a number ?

Inquisitive · Post by **Inquisitive** » Tue Jan 13, 2004 3:18 pm

I need to convert a string into a number. This is needed for performing a mod operation.

roy · Post by **roy** » Tue Jan 13, 2004 3:23 pm

Hi,
Basically DS is type free, meaning that if you take a string and put it in a phrase of numeric meaning it will work if you enshure that it is numeric castable (a number in fact) in a transformer for example.
though types are checked when you read/write data from/into you sources/targets.
IHTH

1stpoint · Post by **1stpoint** » Tue Jan 13, 2004 3:32 pm

I wrote a VAL function a few years back.

It will convert things like "1.244E10", "$5767.88" and other non numeric fields to number.

Teej · Post by **Teej** » Tue Jan 13, 2004 5:12 pm

Inquisitive wrote:I need to convert a string into a number. This is needed for performing a mod operation.

Therefore, you are asking if you need to convert from a string to an integer. Not necessary -- as others have said, DataStage is MOSTLY type-independent. Just lets the mod function rip.

Naturally, you need to ensure that your data is validated as an integer in advance.

However, if you want a decimal values, just use StringToDecimal().

-T.J.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 13, 2004 8:05 pm

If you're using a BASIC Transformer stage (or are in a server job), you can use a BASIC expression. The easiest way is to perform some arithmetic. But you have to be certain that what you're beginning with can be regarded as numeric.

Code: Select all

If Num(inlink.column) Then Iconv(inlink.column,"MD0") Else 0

The Iconv function will remove thousands delimiters and currency symbol. It will also round to the indicated number of decimal places and NOT return the decimal place holder character. Find out all about the "MD" conversion in on-line help from Designer or Manager.

bigpoppa · Post by **bigpoppa** » Wed Jan 14, 2004 8:07 am

PX is not freely-typed b/c it doesn't operate on DS's Basic engine. It uses a separate c-based engine.

I don't know the answer to the original question, but if someone has the APT_Ref cards, could they be kind enough to see if there is a str_to_num function for the APT_String class?

Thanks,
BP

Teej · Post by **Teej** » Wed Jan 14, 2004 10:33 pm

bigpoppa wrote:I don't know the answer to the original question, but if someone has the APT_Ref cards, could they be kind enough to see if there is a str_to_num function for the APT_String class?

There is an "asInteger(APT_Int32, APT_Status)" within APT_String class.

However, what the person would want is a APT_FieldConversion - there's tons of conversion options in it.

This is referring to Orchestrate HTML 6.0 version.

-T.J.

DSXchange