Shell Programming and Scripting

Hi,

I have 24 .dat files something like below. The file name starts with “abc” followed by two digit month and two digit year. Is there a way to grab the month and year from each filename and append it to the end of each line. Once this is done I want to combine all the files into file Master.dat file.
All files are fixed width

abc0103.dat
abc0203.dat
..........................and so on................
abc1203.dat
abc0104.dat
............................and so on till........
abc1204.dat

All files are fixed width and the layout is as below

Field1.... HNUM CHARACTER 1 to 10
Field2.... AKEY CHARACTER 11 to 20
Field3.... BNC CHARACTER 21 to 23
Field4.... AMOUNT NUMERIC 24 to 28
Field5.... BUSS CHARACTER 29 to 29

I want to grab the month and year from each filename and append at the end of each line to the respective files. and create a master.dat file.

I will appreciate any help on this.

Thanks
Raj

This assumes that the only numbers in the filename are the [malformed] date that you want to extract. If that is not the case, change the gsub line to suit the criteria required to extract the date.

Code:

awk '{
  date = FILENAME
  gsub( /[^0-9]/,"",date )
  print $0, date > "master.dat"
}' *.dat