Shell Programming and Scripting

 
I have a filename: TEST2013_09_17_XX_XX_XX.csv
 
Now script should create a new file with name: XX_XX_XX.csv
 
Or I should say i need the output as XX_XX_XX.csv

$ echo 'TEST2013_09_17_XX_XX_XX.csv' | cut -d'_' -f4-
XX_XX_XX.csv
$ echo 'TEST2013_09_17_XX_XX_XX.csv' | cut -d'_' -f1-
TEST2013_09_17_XX_XX_XX.csv
$ echo 'TEST2013_09_17_XX_XX_XX.csv' | cut -d'_' -f2-
09_17_XX_XX_XX.csv
$ echo 'TEST2013_09_17_XX_XX_XX.csv' | cut -d'_' -f3-
17_XX_XX_XX.csv
$ echo 'TEST2013_09_17_XX_XX_XX.csv' | cut -d'_' -f4-
XX_XX_XX.csv
$ echo 'TEST2013_09_17_XX_XX_XX.csv' | cut -d'_' -f4-5
XX_XX
$ echo 'TEST2013_09_17_XX_XX_XX.csv' | cut -d'_' -f-5
TEST2013_09_17_XX_XX

Last login: Wed Sep 18 11:46:02 on ttys000
AMIGA:barrywalker~> file_and_path="~/TEST2013_09_17_XX_XX_XX.csv"
AMIGA:barrywalker~> new_file_and_path="/tmp/"${file_and_path:17:12}
AMIGA:barrywalker~> echo "$new_file_and_path"
/tmp/XX_XX_XX.csv
AMIGA:barrywalker~> _

file=TEST2013_09_17_XX_XX_XX.csv
echo ${file/*[0-9]_/}