How to copy all .xls files from INBOUND folder in Unix

Question

I want to copy all .xls files only from the INBOUND folder to the target folder and convert all .xls files to .csv files.

Below is the code I wrote but it is not working properly.

#!/bin/bash
SRC_PATH=/bishare/IRP_PROJECT/SXM_SFTP/*/INBOUND/*
TGT_PATH=/appinfprd/bi/infogix/IA83/InfogixClient/Scripts/IRP/New_Vendors/Xls_Convert/

cp $SRC_PATH {*.xls} $TGT_PATH

cd $TGT_PATH

for i in
do 
ssconvert i i.csv
done

@Inian- getting coppied with all the file ie .pdf,.xlsx,.jpg and converion not happening. — Midhun CM, Jan 25 '17 at 07:30
Try pasting your code into ShellCheck... http://www.shellcheck.net/# — Mark Setchell, Jan 25 '17 at 13:54

Zumo de Vidrio · Answer 1 · 2017-01-25T10:23:33.700

0

To copy all xls files:

cp /path_to_INBOUND/*.xls /path_to_target/.

To do some action with those files:

cd /path_to_target/
for i in *; do ssconvert i i.csv; done

(Supposing that ssconvert command works in that way, I don't know it)

edited Jan 25 '17 at 10:23

answered Jan 25 '17 at 09:23

Zumo de Vidrio

2,021
2
15
33

@linuxfan Sure! It is also possible (even easier) I edit my answer. – Zumo de Vidrio Jan 25 '17 at 10:23

How to copy all .xls files from INBOUND folder in Unix

1 Answers1