Conversion String to Number

svishaal · Post by **svishaal** » Tue Dec 05, 2006 7:05 am

Hi

I have some set of records, one of the columns of that recordset having expressions in it that is a varchar columns, Now I want to have result of those expressions e.q.

Say.. particular columns having 10/2 values in it... now I want the end result of this expression i.e. 5

This columns can have multiple expression also like 10/2 + 20 now the end result would be 25.

Can anybody tell me how can i do this, how can i convert this string into proper number format in datastage... I can not use Oracle PL Sql ... I just have to use DataStage only...

waiting for reply

Thanks in advance...

ArndW · Post by **ArndW** » Tue Dec 05, 2006 7:53 am

Take a look at this thread for dynamic evaluation using EVAL in Basic. It is rather roundabout and inefficient but will work.