Convert into Number decimal and text combination

[techvarun]

Hi Qlixperts

              I am trying to covert a huge fields into number by the script below

LOAD num(Value_EUR),

-1* num(Value_EUR),

Value_EUR as Value_EUR_Actual

    The field Value_EUR contains combination of numbers and texts and in the num(Value_EUR), field i am getting all the text fields as null

Please help me fixing the code

[tresesco]

try like:

LOAD Evaluate(Value_EUR),