File extension remove from file name using SAP BODS.

[bittu_sharma]

Hi All,

Can you please help me on the command or script using SAP BODS to delete the file extension from file name itself.

example -file Test_839_vs30_csv_20230220_063003.ctl should change to Test_839_vs30_csv_20230220_063003 by using SAP BODS.

can you please help.

Regards,

Bittu

[RichS]

Have you tried using the file_move function within a BODS script? It should work within the same directory and effectively accomplish a "rename". Alternatively, you could use file_copy followed by file_delete.