Linux Shell Script For Each File in a Directory Grab the filename and execute a program

user_235310 0
Viewed 164634

Scenario :

A folder in Linux system. I want to loop through every .xls file in a folder.

This folder typically consists of various folders, various filetypes (.sh, .pl,.csv,...).

All I want to do is loop through all files in the root and execute a program only on .xls files.

Edit :

The problem is the program I have to execute is 'xls2csv' to convert from .xls to .csv format. So, for each .xls file I have to grab the filename and append it to .csv.

For instance, I have a test.xls file and the arguments fro xls2csv are : xls2csv test.xls test.csv

Did I make sense?

shell linux
4 Answers

bash:

for f in *.xls ; do xls2csv "$f" "${f%.xls}.csv" ; done
Ignacio_Vazquez-Abrams_208620

Look at the find command.

What you are looking for is something like

find . -name "*.xls" -type f -exec program

Post edit

find . -name "*.xls" -type f -exec xls2csv '{}' '{}'.csv;

will execute xls2csv file.xls file.xls.csv

Closer to what you want.

user_633090 
find . -type f -name "*.xls" -printf "xls2csv %p %p.csv\n" | bash

bash 4 (recursive)

shopt -s globstar
for xls in /path/**/*.xls
do
  xls2csv "$xls" "${xls%.xls}.csv"
done
user_1315270
Related