Shell Programming and Scripting

I am new to scripting world,

My requirement is I have set of filenames , I have to search for the specific file names, then from each of the file I have to cut the month and year inforamtion , then add that value as additional column to each record. these files are comma delimited file.

files in the input directory is

"usa_newjercy_042008.dat"
"usa_newjercy_012009.dat"
"usa_ohao_042008.dat"

I have to search newjercy files usa_newjercy*.dat files and I have to copy month and year from the file and add that info to each record in that file.

Please help me onthis.

Hi,

After reading 5 times your text, i must admit i understand nothing

Hope that someone will.

Hi ,

I have list of files in the input directory

I have specified the file format

files in the input directory is

"usa_newjercy_042008.dat"
"usa_newjercy_012009.dat"
"usa_ohao_042008.dat"

I need to read the newjercy state files and cut the numaric part from the file , past the value to each record in the file.

What would be the expected output?

One of the things that imagine could be is:
usa_newjercy_042008.dat 042008
usa_newjercy_012009.dat 012009
usa_ohao_042008.dat 042008

Hi,

And what is the record format.
Example of input file and outputfile could help.

Hi all,

The file names are

"usa_newjercy_042008.dat"
"usa_newjercy_012009.dat"
"usa_ohao_042008.dat"


recod format is :

1,abc
2,def

grep the 042008 from "usa_newjercy_042008.dat" file and append to record

output is :

1,abc,042008
2,def,042008


I have to repete the same process for all the files. by grep the numaric info from the file name

If you already have a file with all these file names (without quotes):

Code:

#!/usr/bin/ksh
while read mFname
do
  mMMDDYY=$(echo ${mFname} | sed 's/.*_\(.*\).dat/\1/')
  echo $mMMDDYY
  sed "s/$/,${mMMDDYY}/" ${mFname} > Temp_File
  mv Temp_File ${mFname}
done < inp_file