UNIX for Dummies Questions & Answers

us_Gec1_wk_01to01_2008.TXT
ad_EngEnt_wk_01to10_2008.TXT
br_EngMov_wk_01to10_2008.TXT

[house@discovery] echo "ad_EngEnt_wk_01to10_2008.TXT" \
       | awk -F "[_.]" '{print $4}' | awk -F "to" '{print $1}'
01
[house@discovery] echo "ad_EngEnt_wk_01to10_2008.TXT" \
       | awk -F "[_.]" '{print $4}' | awk -F "to" '{print $2}'
10
[house@discovery] echo "ad_EngEnt_wk_01to10_2008.TXT" \
       | awk -F "[_.]" '{print $5}'
2008

 

$ echo "ad_EngEnt_wk_01to10_2008.TXT" | cut -b 14-15
01
$ echo "ad_EngEnt_wk_01to10_2008.TXT" | cut -b 18-19
10
$ echo "ad_EngEnt_wk_01to10_2008.TXT" | cut -b 21-24
2008

Fromdate=`echo "ad_EngEnt_wk_01to10_2008.TXT" | cut -b 14-15`;
echo "Fromdate:"$Fromdate;
ToDate=`echo "ad_EngEnt_wk_01to10_2008.TXT" | cut -b 21`;
echo "ToDate:"$ToDate;
Year=`echo "ad_EngEnt_wk_01to10_2008.TXT" | cut -b 21-24`;
echo "Year:"$Year;

From_date = cat files | cut -d'_' -f 4-8 | cut -d 't' -f 1
To_date = cat files | cut -d'_' -f 4-8 | cut -d'o' -f 2 | cut -d '_' -f 1
Year= cat files | cut -d'_' -f 4-8 | cut -d'o' -f 2 | cut -d '_' -f 2 | cut -d'.' -f 1