Converting author names in a single unified format

Greetings, dear community!

  For example, I have a reference with the following text in Author field:

Herbert H. Yuan
Swanson, B. F.

  However I want to find a automatic way to convert this to

Yuan, Herbert H.
Swanson, B. F.

  Is there a way for this conversion of multiple references?

Thank you for the prompt rely.

You could use the Find and Replace option.

Not easily.  Another way,  (except it is hard to retain linked PDFs) is to export the records to a RIS file, with the authors exported in the Surname, Firstname firstInitial order and then import them back into a new library or into the same library and then remove the duplicates (which you may have to modify the rules to not consider authors). 

Thanks.

Can I use regular expressions while doing Find and Replace?

@akazak wrote:

Thanks.

Can I use regular expressions while doing Find and Replace?

Sorry, but don’t understand what you mean by "regular expressions ".  Endnote’ s  Find  and Replace  command does permit includingthe following : carriage return, tab, match case, match words,  and style changes (bold, italics, underline, plain text, superscript, subscript, or symbol font). 

Refer to the attached image for the set up using Endnote’ s Find  and Replace  command based on your example. Note that once the changes are made, they cannot be undone. So make a backup copy of your library before making changes.

find and replace.gif

I mean regular expressions or RegExps — standard for text search and replace. A regular expression (regex or regexp for short) is a special text string for describing a search pattern. You can think of regular expressions as wildcards on steroids. You are probably familiar with wildcard notations such as *.txt to find all text files in a file manager. The regex equivalent is .*.txt$.

The suggested way is good, but not generic at all. For example I should preform such replacements for ever author with undesired name. RegExps would allow search and replace for all patterns at the same time.

Endnote’ s Find and Replace command is pretty specific. While somewhat similar to what is found in a word processing program its parameters are narrow and may not have the capability you’re seeking. For further information, go to the HELP section of the Endnote toolbar and look up “Find and Replace”.

I wish one day EndNote will have Regular Expression capability in Find and Replace.

@leanne wrote:

Not easily.  Another way,  (except it is hard to retain linked PDFs) is to export the records to a RIS file, with the authors exported in the Surname, Firstname firstInitial order and then import them back into a new library or into the same library and then remove the duplicates (which you may have to modify the rules to not consider authors). 

 

 

Can you elaborate more on this method please?

Not without doing it to describe it step by step and currently I am out of town and away from my Endnote library and computer.  Try testing it, by exporting (file> export) your library using the RIS endnote (select that output style from the dropdown in the export menu, lower right) output style, and try importing that file into a new library (create new library and file>import).  I think it should import as surname, first name – if not, I should be able to give more detailed instructions next week.  But apart from individuals with double barrel names, it should not be necessary to fix this?