Shell Programming and Scripting

Hi Gurus
I want to extract a date and version code which shall come in filename consisting of underscores.
The filename can contain any / one underscores but the version number will come after date and will be separted by underscore
String formats
=============
ABC_20090815_2.csv
ABC_DEF_20090815_2.csv
ABC_DEF_GH_20090815_2.csv
ABC_DEF_G_I_20090815_2.csv
ABC_DEF_M_N_O_P_20090815_2.csv

In each case i want to extract
date -- 20090815 and
version number -- 2

Try

Code:

$ echo ABC_DEF_M_N_O_P_20090815_2.csv | awk -F '[_\.]' '{ print "date: ",$(NF-2), "\nversion: ",$(NF-1) }'

sed version :

Code:

sed 's/.*_\(.*\)_\(.*\).csv/\1 "version" \2/' file_names_file

There's no need for any external command. Use the shell:

Code:

IFS=_.
for file in *.csv
do
  set -- $file
  shift $(( $# - 3 ))
  echo "date=$1"
  echo "version=$2"
done

Thanks for all your replies .. just one more scenario ..

The file name can end without .csv as well

ABC_20090815_2
ABC_DEF_20090815_2
ABC_DEF_GH_20090815_2
ABC_DEF_G_I_20090815_2
ABC_DEF_M_N_O_P_20090815_2

still how to extract date and version

Thanks much

Should be suffice

Code:

while read file
do
echo "$file Date and Ver: `echo $file | grep -o '[0-9]\{8\}_[0-9]'`"
done < file

just play with the code for formatting

Hey, just modify panyam's command a bit and it's done:

Code:

sed 's/.*_\(.*\)_\(.*\)/\1 version \2/' yourfile