Batch editing references

Question

I imported many pdf articles into Mendeley but saw that Mendeley did not capture all the fields correctly. So, I needed to change them manually. It would be a tedious job to do so with many documents. Fortunately, many of the documents share common journal names and years. So, I needed a way to edit them together.

Is there a reference manager where we can edit selected references in one go without having to do this for each reference individually?

I have tried Endnote. Mendeley, and JabRef so far but could not find such a way. I will be grateful if someone has any idea/experience in this direction.

Edit-1:
After solving the batch editing problem, I also had a problem with getting the syntax for the authors correct.

Answer 1

Mendeley does it actually. I did not try properly before. Then I had a problem with getting the authors correct. What you need to do is put them as follows

Last Name, First Names
Last Name, First Names

and so on.

After Edit-1:
Another useful thing in Mendeley is that, you just have to select the authors from the pdf and Mendeley will give suggestions on the syntax based on existing authors in the current database. See the following image.

Answer 2

If you use bibtex, then you can batch edit with things like sed, awk, or simple find/replace in any text editor.

Answer 3

In my experience, the author syntax changes if you're using DOI or PMID. In addition to the method that @Stat-R suggests, if you filter by authors, you can simply drag and drop author names onto each other and they will merge into your designated syntax.