Skip to Content
0
Former Member
Jun 17, 2013 at 06:29 AM

Char to Numeric conversion

150 Views

Hi

We are running on Information Steward 4.0

I am urgently looking for a solution for a rule where I need to convert a value from a table defined character field into a numeric value. I have searched the available documentation but have not found anything.

I tried applying the Convert to Decimal but when I run the rule it fails stating "Option <to_decimal_ext> must contain a constant value, not a variable, parameter, or column reference"

appreciate your help

regards

Ed