Using batch script to find filename and run a convert command using that filename

Question

I'm attempting to grab a text file from a folder for conversion to .xls using ssconvert. Currently I have:

for /F %%a in ('dir /b *.txt') do set FileName=%%~na 
ssconvert %FileName%.txt %FileName%.xls

However this results in this being run:

ssconvert thefile .txt thefile .xls

Which obviously doesn't work.

How would I get rid of the space between the FileName variable and the file extension?

Dr. belisarius · Accepted Answer · 2011-02-24 15:34:28Z

1

Try:

for /F %%a in ('dir /b *.txt') do  ssconvert %%~na.txt %%~na.xls

answered Feb 24, 2011 at 15:34

Dr. belisarius

61.2k15 gold badges121 silver badges198 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

GolezTrol · Accepted Answer · 2011-02-24 15:31:47Z

0

I think it has something to do with %%~na needing to be just %%a.

answered Feb 24, 2011 at 15:31

GolezTrol

116k19 gold badges186 silver badges215 bronze badges

I had a space in the batch script after ~na , making this completely my fault! Cheers anyway