ETL and Data Integration tools - Modern ETL software for everyone

Hello,

we are planning to purchase your Advanced ETL tool and currently we are testing trial version.

So far looking good, but one problem occurs.

Calculation below is working fine in Transformation editor, but once saved and trying to open again Transformer properties ”’OP=1’ is not a valid integer value” error message occurs. It also prevents running transformation task.

Please advice.

Thanks and regards,
Bill


var
data:string;
search:string;
i:integer;
begin
data:='[F001]';
For i:=1 to 2 do
begin
Case i of
1 : search:='something';
2 : search:='something else';
end;
if pos(search,data) = 1 then
begin
Result:=copy(data,length(search)+1,100);
exit for;
end
else
Result:=data;
end;
end;

Hello.

Just did the same with the latest version.
Worked fine for me
Which version have you got?

Mike

I found it !

my search string was

1 : ’ID=';

The equal character was the problem…

Thanks
Bill