ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I'm trying to use this simple calculation

Begin
Result:= StrToFloat([F001]) - StrToFloat([F002]);
End;

but the result is always null.

I suspect the problem is the number format: decimal separator is coma.

Thank you for the support

Download latest version and use

begin
result:=StrToFloat(Replace([F001],',','.'))+StrToFloat(Replace([F002],',','.'));
end;

Peter

The problem is the number string which is like 0000120,45

The replace function works well with the decimal separator but the string conversion function does not manage the leading zeros; also tried with Ensure no prefix function but I guess it requires the exact number of leading zeros...

Any suggestion?

Just tested it again with version 3.2.2.13

It does work

I've even put spaces in front of 0000120,45

Mike

Ok, it works!!!

Maybe it's my fault; what I changed since last time is the 'on error' behavior in the calculation properties: when set to 'Set to Null' calculation fails (it always returns null) but it works fine when set to 'Abort processing'.

Thank you

Sorry but calculation function is not working well when numeric inputs are like '0000111'

Separator replacement is ok, the StrToFloat function maybe not, see the attached file

bye
C.