append text betwen a certain range

[mikey555]

Hi folks,

I'm in the process of a large archival process. I have thousands of tapes, each with a copy number starting with an abbreviation of the department they were shot for (e.g. AAS, CJS, COE, ETS, it doesn't matter what they stand for, but it's how they're identified). The copy number is in this format: DEPT-YYYYMMDD (e.g., ETS-20110511). All of the tapes are in the database.

The tapes are going into large boxes. Boxes are simply named box### (e.g., box079), and new boxes are created in order with no regard to its tapes' copy numbers.

I'd like to make a script that takes, as input, a range of alphabetical departments to be tagged, or just a range of selected tapes, as well as a year, and a box#. The box number will be appended to the beginning of the 'comment' column entry of each tape between the given range and on the given year.

Any ideas? Any help is appreciated!

Thanks,

Michael

[comment]

I'd suggest you use a separate field for the box number.