Hi,
I have files with filenames as below.
SGM Daily Sales Email-en-us-05312012.xlwa
I want to rename it in .xls. I am writing a script to change this, as there can be multiple files in subfolders.
I have the following script.
#!/bin/ksh
for oldfile in $(find /usr/local/data/vstar/report_repository -name "*.xlwa")
do
newfile="$(echo $oldfile | sed 's/.xlwa/.xls/g')"
mv "$oldfile" "${newfile}"
done
this is the log of it.
find /usr/local/data/vstar/report_repository -name "*.xlwa"
++ find /usr/local/data/vstar/report_repository -name '*.xlwa'
+ for oldfile in '$(find /usr/local/data/vstar/report_repository -name "*.xlwa")'
echo $oldfile | sed 's/.xlwa/.xls/g'
++ echo /usr/local/data/vstar/report_repository/SGM/SGM
++ sed s/.xlwa/.xls/g
+ newfile=/usr/local/data/vstar/report_repository/SGM/SGM
+ mv /usr/local/data/vstar/report_repository/SGM/SGM /usr/local/data/vstar/report_repository/SGM/SGM
mv: cannot stat `/usr/local/data/vstar/report_repository/SGM/SGM': No such file or directory
+ for oldfile in '$(find /usr/local/data/vstar/report_repository -name "*.xlwa")'
echo $oldfile | sed 's/.xlwa/.xls/g'
++ echo Daily
++ sed s/.xlwa/.xls/g
+ newfile=Daily
+ mv Daily Daily
mv: cannot stat `Daily': No such file or directory
+ for oldfile in '$(find /usr/local/data/vstar/report_repository -name "*.xlwa")'
echo $oldfile | sed 's/.xlwa/.xls/g'
++ echo Sales
++ sed s/.xlwa/.xls/g
+ newfile=Sales
+ mv Sales Sales
mv: cannot stat `Sales': No such file or directory
+ for oldfile in '$(find /usr/local/data/vstar/report_repository -name "*.xlwa")'
echo $oldfile | sed 's/.xlwa/.xls/g'
++ echo Email-en-us-05312012.xlwa
++ sed s/.xlwa/.xls/g
+ newfile=Email-en-us-05312012.xls
+ mv Email-en-us-05312012.xlwa Email-en-us-05312012.xls
mv: cannot stat `Email-en-us-05312012.xlwa': No such file or directory
So whenever there is a space in the filename, it is taking as a different file..
Could somebody help me out here..
Cheers!!!!!