Dynamic Rename - How to rename extension?

HI,
In continuation of my previous question , I have a file location defined in 
#EName# containing value

C:\Users\Superadmin\Documents\KBIAutomation\eomaterial\input\eomaterial.csv

I wish to rename this to eomaterial.xlsx


 

In this case you have to use calculated parameter.



begin
 Result:=ChangeFileExt(GETVARIABLE('#EName#'),'.xls');
end;

I have attached the package for your convenience


 

Thank you Pascal for the win , my python script here kept failing 

Please let us know if you find the way to do the same using python. We will add it to the documentation.   

admin wrote:

Please let us know if you find the way to do the same using python. We will add it to the documentation. 

 

Team Pascal has cheated , some bug somewhere irrespective of what I try , I get the same error 

Following Error happened: Could not convert variant of type (UnicodeString) into type (Boolean) . Loop work once and fails