Shell Programming and Scripting

I've got a multitude of text data files that carry exactly the same kind of data. Unfortunately some of them have a different filename format

some are: 'category'_'month'-'year'_act.txt

an example being: daf_Apr-1961_act.txt



and some are: 'category'_ 'year'-'month'_act.txt

an example being: daf_1961-04_act.txt


any suggestions for transforming the former to the latter?

Shell script is the only option here.Try using case.Following can be tried..

Code:

case $name in
          01 ) $month=Jan
              ;;
          02 ) $month=Feb
              ;;
             ....... so on
      esac
  done

Thanks Nua7

What about rearranging the sequence of the file title = swapping the month and the year around. I was more concerned if that was possible.

Yes that should be possible, Split the file name in variables as $category, $date, $month and rearrange as you wish..

Thanks!
nua7

Something like this?

Code:

$ echo "daf_1961-04_act.txt"|sed 's/\(.*_\)\(.*\)-\(.*\)\(_.*\)/\1\3-\2\4/'
$ daf_04-1961_act.txt


$ echo "daf_Apr-1961_act.txt"|sed 's/\(.*_\)\(.*\)-\(.*\)\(_.*\)/\1\3-\2\4/'
$ daf_1961-Apr_act.txt

Regards

This is Fantastic Franklin52..!!

vrms , that should work..

Thanks guys this is great stuff!!

However, this might be me being very dumb, but is there a way of 'saving' this new file name to the original. And could this then be automated to do more than one file at a time. Sorry I'm a bit new to this.