You can actually make your export style, such that first field (Journal, Year or whatever that doesn’t have CR) is formatted as Bold font. Then, Ctrl+K to the Word document. You would expect each line starts with Bold font. If you find a line, that doesn’t start with Bold font, there should be an unexpected CR somewhere in the output.
Sometimes, book sections and things alike may have CR “within” a filed data. So, you would be able to detect such anomaly using this method.
Alright, will try to do that as well. So far:
I copied formatted to Word
Imported to Excel
All appears normal save a few exceptions where page numbers appeared as dates; book sections appeared out of order
I added hyperlinks for e-copies of articles using Excel so that database info will be available to other staff who do not have Endnote
This saves me much time because I am the only one with Endnote and am responsible for updating articles on a monthly basis in a system-wide Excel sheet, a soft .pdf library, and a hard copy archive. I think I will need to do this export on a monthly basis to make sure all is up to date. This allows me to simply do it once in Endnote then do the export without the added data entry. Will also have to make a few changes so that all fields that do not transfer correctly will appear correctly in Excel.
Thank you so much for your assistance; again, will follow up re: the boldface option in first fields to root out anomalies. You’re a lifesaver.
Very obvious follow up question I neglected to ask:
Is there also a way to export from Excel and import in EN? I’m not sure reversing the methodology would work. Would prefer some guidance vs. doing what I did yesterday and accidentally causing VERY BAD CHANGES to essential files. Fortunately, was able to get it back.
Thanks again