Remove the space between the variable and the constant part of a file name

Hi everyone,

I have 800+ files the problem is that the file name ends in 80 different combination so I need to try all of those for each file.
eg: one of the 800 is "109 st no 103 av" the file could be called:
"109 st no 103 av nb1_cleaned.xls" or
"109 st no 103 av nb 1_cleaned.xls" or
"109 st no 103 av nb 1._cleaned.xls" or
"109 st no 103 av sb1_cleaned.xls"
.
.
.
.etc

I worte a code to try all those combinations, the issue lies a space the code adds before _cleaned, any ideas how to remove it?.

So the name should be
"109 st no 103 av nb1_cleaned.xls"
but my code is letting it be
109 st no 103 av nb1 _cleaned.xls

where the variable Ord is the "1" after nb.

Please find the code below:

Please Login or Register  to view this content.

Any help is appreciated!!

Hi

Add trim function to filename, Check the below code,

Please Login or Register  to view this content.

Hope this will solve your problem.


Regards,
Paresh J