EndNote List Archive
Archive by date
This Month By Date
This Month By Topic
change author field
|change author field
Author: Mark W Sandstrom
Posted: 17/08/2001 17:34:21 GDT
|I have a library with about 2000 references in which the author field was
incorrectly parsed. The authors are listed on one line like this: "Ahmad,
R.Kookana, R. S.Alston, A. M.". Endnote wants the authors one per line:
Kookana, R. S.
Alston, A. M.
I can't see a way to modify the field using change text, because replacing all
periods with return will not be correct for authors with more than one initial.
Mark W. Sandstrom
|Re: change author field
Author: Duncan Branley
Posted: 21/08/2001 12:08:20 GDT
|--On 17 August 2001 10:34 -0600 Mark W Sandstrom wrote:
> I have a library with about 2000 references in which the author field was
> incorrectly parsed. The authors are listed on one line like this: "Ahmad,
> R.Kookana, R. S.Alston, A. M.". Endnote wants the authors one per line:
> Ahmad, R.
> Kookana, R. S.
> Alston, A. M.
> I can't see a way to modify the field using change text, because
> replacing all periods with return will not be correct for authors with
> more than one initial.
Unfortunately you can't do this within EndNote as you import because author
identification only covers one character (I was trying to do something
similar recently and was told this by Henry Johnson from ISI tech support)
You are fortunate though that there is a pattern in your text:
Ahmad, R.Kookana, R. S.Alston, A. M.
The boundary between one author and the next is when there is a full stop
(period) followed immediately by a (capitalised) character. In multiple
initial situations there is a space after all but the last initial.
I don't know if you can search and replace for "no space" within EndNote -
it could well be a useful feature. I can't find reference to it in the
manual. You could do it 26 times - once for each letter of the Western
alphabet ignoring diacritics (".A", ".B" etc) - but I can't get it to work
for no intelligible reason.
Another (shorter 3 step) way might be to do the following:
(1) Replace all full stops followed by a space with something unusual:
". " with "---"
(2) Replace all remaining full stops (the ones before the first letter of
the next name since there was no space after it) with full stop and
"." with ".CTRL-ENTER" (press CTRL-ENTER don't type in the words)
This puts eachauthor in the format described above onto separate lines.
(3) Reverse stage one: replace all --- with a full stop and a space:
"---" with ". "
That has given me exactly what you want.
Alternatively you could try exporting your EndNote library working on it
with (even) Word which has more sophisticated pattern matching. You'd need
to be careful about fields with multiple paragraphs when you re-import
I'd go for the middle option myself.
Don't forget to backup your database first in case you inadvertently do
something not quite right.
Hope this helps,
Applications Officer, Information Services
Goldsmiths' College, University of London
New Cross, LONDON SE14 6NW
Tel: +44 (0)20 7919 7708 Fax: +44 (0)20 7919 7556
Previous by date: Import Filters and New Lines - EndNote 5, Duncan Branley
Next by date: using EN for slide collections?, Timothy Parker
Previous thread: difficultés, Jean-Marie THOULON
Next thread: using EN for slide collections?, Timothy Parker