08-13-2009 04:03 AM - edited 08-13-2009 04:03 AM
Hello!
We are using EN X1 and for our department literature database (about 2000 entries - we do not have the time for manual labels ;-) ), we need a style with the first three letters of the first author and the year of the publication, so for example for
1. Dhiman, R., A.G. McDonald, and S. Chandra, Predicting splat morphology in a thermal spray process. Surface and Coatings Technology, 2007. 201(18): p. 7789-7801.
it would be [Dhi07]
How can this be done?
thanks for any help!
Nils
08-15-2009 12:44 PM
08-15-2009 12:57 PM
08-15-2009 01:03 PM
08-17-2009 03:50 AM
08-17-2009 11:58 AM
Well, at risk of mentioning the "Z" word, it doesn't seem to have this ability either (Discussion). But you might find some of the discussion and links helpful?
08-17-2009 04:59 PM - edited 08-17-2009 05:06 PM
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.
08-18-2009 02:23 AM
08-18-2009 09:47 AM
No, you would have to export your library, add the modified labels and then import again. Not elegant, I agree.
The problem I see, is that this style is very specific: 3 first of 1st author letters with and without a, when is the a introduced, only when a b is present? or would there be a MEY09, MEY09a, etc- what happens if the authors last name has only 2 letters?
And has a number of variants that I found on with some googling -- 4 first letters of 1st author; the first letter of the first 3 or 4 authors, Which complicates matters.
And would the a,b,c you suggested be hardwired or is it publication specific? Is this a specific fix, you are suggesting or is this a published requirement?
All of this must be taken into account before the company undertakes the modification of the database programming and macros development within the program. A need so specific might be solved by the organization requiring the style? I think that is what developers have done here with merlin which I don't pretend to understand.
good luck!
08-18-2009 11:01 AM