It’s not en elegant solution, but you could make an output file that can be imported excel, and use excel’s LEFT/RIGHT function and CONCATENATE function. To extract 3 letters of the first author’s last name, use LEFT function. To extract 07 from 2007, use RIGHT function. Then, concatenate these two letters using CONCATENATE. Square brackets can be handled by Endnote.
You could do the similar thing using Filemaker Pro which has a powerful text handling functions. Once new filed is made, import them back to Endnote. This one can’t do the “a”, “b” thing, so you need to identify them manually. The question is how much you are familiar with export to Excel or Excel’s text function, or Filemaker.
I made a quick sample of these functions in Excel spread sheet, but couldn’t upload because it’s got .xls extension. (This forum doesn’t allow attachments having xls extension!!). I’ll try sending personal message to you.
Message Edited by myoshigi on 08-17-2009 03:06 PM
Message Edited by myoshigi on 08-17-2009 03:06 PM