In The Business of Editing: The AAE Copyediting Roadmap VIII, I began discussing the macros I use during editing. My discussion continues with the Enhanced Search, Count, and Replace (SCR) macro.
I use SCR frequently during editing. The macro searches the text looking for a selected word or phrase (in the example shown below, “Ebola virus disease (EVD)”) and tells me how many times it appears in the text and in what form. The first step is to select the word or phrase to be checked, as shown here (you can make this image, as well as other images in this essay, larger by clicking on the image):
Once I have selected the search term, I run SCR. The macro automatically will “create” search variations (see image below). I can choose to let the macro search for all (leave all of the “Include” checkboxes checked) or some (uncheck those I don’t want included in the search) of those variations and by clicking the “Add terms” button, I can add variations I want included in the search (e.g., I could add “eVD” or “ebola Virus disease”). Usually I just leave all of the items checked and do not add additional terms; occasionally I make additions and changes.
Tip: Be sure to check what the macro is going to search for and think about it. Macros are dumb and do exactly as instructed. Consequently, if your search phrase is “T-helper (Th)” the macro will find every word that begins “Th” or “th” or “TH”. The search has the same limitations as the standard Word search. Sometimes there is no avoiding getting a return with excess information, but other times a tweak in the search term (e.g., unchecking “Th” and adding “Th-1” and “Th1”) can accomplish what you want.
Clicking OK starts the the text search. SCR searches from the point of the selected text to the end-of-text bookmark (the remhigh or refs bookmark); the search begins with the first alphanumeric character following the selected term or phrase. In my work, I do not want it to search references, tables, or figure legends; I just want the main text searched. The search is quick, and produces a report similar to that shown here:
In this sample search, two instances of “EVD” and no instances of “Ebola virus disease” were found. Because this client has a general rule (I write “general” because there are times when the rule is not applied) that an acronym/initialism has to appear more than three times in the chapter (if it does not, then instances of the acronym/initialism have to be spelled out; if it does, then subsequent instances of the spelled out version need to be converted to the acronym/initialism), I know to convert “EVD” to “Ebola virus disease” in this chapter. I do so by entering the text in the replace field as shown here:
Clicking OK will cause the macro to replace those instances of “EVD” with “Ebola virus disease” as shown below. Note in the image that the change is automatically made with tracking on.
I repeat the procedure in the next images to show what happens when there are more than a few options found. In this next example, the chosen phrase is “World Health Organization (WHO)”:
The SCR macro automatically looks for the variations shown here:
and returns the report shown here:
There are 75 instances of WHO (#1 in above image) and two instances of World Health Organization (#2) in the chapter. Applying the client’s rule, the 75 instances of WHO need to be highlighted (#3) and the two instances of World Health Organization need to be changed to WHO (#4).
Tip: The count that is returned by the SCR macro does not include the original selected text. In this example, the selection was “World Health Organization (WHO)” (see earlier image), so that instance was not included. What that means is that the true count is 76 instances of “WHO” and three instances of “World Health Organization” appear in the text. Had I selected only “World Health Organization” as the search text, “WHO” would not have been counted unless I manually added it as an additional search term, meaning that the search result would have been three instances of “World Health Organization”.
When searching, the macro (most of the time, but not always) ignores parentheses and square brackets. To make it easier to add additional variations or to enter replacement text, when I select the text to be searched for, I also copy it to the clipboard. That way I can paste the phrase into the appropriate blank field rather than type it and just make adjustments to the original search text to create additional search variations. Most of the time that works easily; sometimes it is easier to type what I want added.
To highlight the instances of WHO, I check the Highlight box (#3) for those that I want highlighted. The purpose of highlighting the text is so that as I edit the chapter, I can see that I have already made sure that the acronym/initialism has been spelled out and/or that the phrase has been checked (perhaps, e.g., I confirmed that the spelling or name is correct, such as “bevacizumab” or “chikungunya” or “Chinese National Biotec Group”). To change “World Health Organization” to “WHO”, I type “WHO” in the Replace Text field (#4).
Clicking OK causes SCR to do the designated tasks. When done, the results appear as shown here:
Instances of “WHO” have been highlighted (#1, #3, and #4) and the two instances of “World Health Organization” (#2 and #3) have been deleted and replaced by “WHO.” Note, however, that the first instance of “World Health Organization” (#1), which is the instance that I had selected for the search term (see earlier image) remains. Note also that the deletions of “World Health Organization” and the additions of “WHO” are shown as tracked changes. If tracking is off, SCR turns tracking on, makes the changes, and turns tracking off; if tracking is on before it runs, it leaves tracking on when it is finished.
SCR performs another very valuable function in my editing: It helps me determine whether the acronym/initialism or the spelled-out version predominates. It is not unusual to get a report indicating the acronym/initialism appears, for example, five times and the spelled-out version appears six times. When that happens, as the editor I need to decide which form to use and which to replace. Of course, also entering the decision-making process is how I will justify my decision and whether I have an explicit instruction from the client that tilts the balance scales toward a particular response.
Tip: I also use SCR to determine whether a phrase appears in another form later in the text. For example, if I come across the phrase “tumor necrosis factor beta,” I will run SCR and add these 11 search terms using the “Add terms” feature:
- tumor necrosis factor-beta [note the hyphen]
- tumor necrosis factor–beta [note the en-dash]
- tumor necrosis factor β
- tumor necrosis factor-β
- tumor necrosis factor–β
- TNF-beta
- TNF–beta
- TNF-β
- TNF–β
- TNFβ
- TNFbeta
When I get the report, I can determine whether any of the 12 phrases (the original selection plus the 11 added terms) appear later in the text and if they do, how often. That allows me to decide which form to use and which ones I need to change so that usage is consistent — and to make any necessary changes immediately. SCR is another tool in my consistency arsenal. Once I make the decision, assuming this is my first encounter with the phrase, I note my decision on the stylesheet and add the change to the Never Spell Word project-specific dataset (see The Business of Editing: The AAE Copyediting Roadmap V) so that the change is implemented in all subsequent chapters.
SCR is a more sophisticated form of Word’s Find & Replace function. Using Word’s Find & Replace requires multiple searches to be sure that most of the likely variations have been searched for. In addition, using Word’s Find & Replace doesn’t provide an easy way to mark text so that you know you have already checked it and it is okay.
Although the examples I use are nonfiction, SCR is a great tool for fiction editors. For example, you can search for character names and spelling variations (Mariah, Marya, and Maria are three spellings of the same name — although if the results came back Mariah = 100 and Maria = 63, I would query the author [and myself] whether these are the same character or different characters, and if the same character, which is the correct spelling).
Which leads us to…
It’s the rare manuscript that can go through editing and not have comments or queries inserted; in all of the hundreds of manuscripts I have edited, there have only been two or three. The Business of Editing: The AAE Copyediting Roadmap X discusses how I use, insert, and edit comments/queries during editing.
Richard Adin, An American Editor
The Business of Editing: The AAE Copyediting Roadmap X
Tags: AAE approach to editing, Comment Editor, comments, copyediting roadmap, guide to copyediting, Insert Query, methodology, queries
In The Business of Editing: The AAE Copyediting Roadmap IX, I discussed the Enhanced Search, Count, and Replace (SCR) macro and how I use it while editing manuscript. This essay deals with inserting queries/comments into the manuscript during editing.
When I first began freelancing, a client (an in-house production editor) told me that as important as good editing skills are, even more important is how authors are queried. The reason, the editor said, is that when I speak to the author, I am speaking on behalf of the client. Of course, that got me thinking about comments and led me to the realization that comments are not only important as alerts to clients and authors about potential problems, but as a marketing tool for me. I wish I could say that I never let frustration with a manuscript or a client appear in comments I have inserted, but I can say that when the frustration appeared, I had made a conscious decision to let it appear.
Querying the author or the in-house editor or the compositor is usually done in one of two ways: (a) inserting the comment inline in the text or (b) inserting the comment as balloon text such as is done using Word’s Comment feature. Because time is money in my editorial business, I rely on EditTools’ Insert Query and Comment Editor macros to insert queries. (For this essay, “queries” and “comments” are used interchangeably and the one includes the other. The oft-stated distinction between the two terms is that a query asks a question whereas a comment makes a statement [e.g., “AQ: Is it OK/correct that I changed 1 to 2 to conform with the previous quantity?” is a query, whereas “Ed/COMP: This needs to be set in sans serif.” is a comment].) Insert Query lets you choose between inserting the comment as a Word comment (balloon text) or inline, as shown here (you can make an image in this essay larger by clicking on the image):
Choose method for inserting a query
I have repeatedly said that time is money when editing. My goal is to minimize the time I need to spend doing “routine” tasks and maximize the time I have available for actual editing. Prior to Insert Query, I had to keyboard every query, even if it was the same query, perhaps with some modification, as inserted a dozen times before in the manuscript. Keyboarding slowed me down considerably. Although I have become a fairly decent typist over the years, I still am neither a fast typist nor one with 100% accuracy. So, keyboarding a query longer than a few words took (takes) time — time for the original keyboarding and time to review that keyboarding and time to correct the errors in my keyboarding.
Using keyboard shortcuts sped up the process but was limited for many reasons. After a while it became difficult to remember all of my keyboard shortcuts — I had them for everything, not just for queries — and there was a limit to how many quickly accessible keyboard shortcuts I could create. I eventually kept a list of my keyboard shortcuts, but that wasn’t a panacea because as the list grew, I had to take the time to look up the shortcut. Also complicating the situation was when I needed to modify a query: the original query was written for Jones on Capitalistic Medicine and now needs to be modified for Smith on Mercy Medicine. These and other limitations and problems led to the Insert Query macro.
As the image below shows, using Insert Query I am able to store a large number of “standard” queries (#A in image; the count shows the number of saved queries for the Reference Queries tab [#1] only) and access them as I need them. To make it easier and quicker to access a query, I separate the queries into categories (#2) that I create. After selecting the category, I select the query (#3) I want to insert. The selected query appears in the “insert” windows (#4), where I can modify the query if necessary. In this example, there are three underscores that need to be replaced with the relevant information. It is in this field (#4) that I make the change, after which I click Insert to have the query inserted in the text as a balloon comment.
Selecting, modifying, & inserting a query
One of the tabs is a project-specific tab (#5 in the image below; all of the tabs work the same, so you can not only rename any of the tabs, but you can have multiple project-specific tabs). As is shown at #B, this tab has 104 available project-specific queries from which I can choose. What I do is copy a query that I need for a project from one of the other tabs and add it (clicking Add to add it to the dataset rather than Insert to add it to the document) to the project-specific dataset. When I am done with a project, I copy those queries that I specially created for the project and that did not come from another tab that I think will be usable for other projects to one of the other tabs.
Project-specific queries
Take a look at the query shown in the above image (#6). How many times would you like to type it? Once was enough for me. Yet look at the query. The query packs a lot of information and shows that I did my job. It tells both the client and the author that I am competent and knowledgeable. Most importantly, as several clients have commented on seeing this and similar queries, it tells the author that the client has selected a professional editor and that the client cares about the author’s book; it gives the author confidence in the quality of the editing and competency of the editor; and it confirms to the client that a wise choice was made when I was selected to edit the book. In other words, it acts as a marketing tool.
It is easy to “perfect” a query when you only have to think of it once and only have to keyboard it once. In addition, it is easy, with a tool like Insert Query, to maintain a library of queries. Because I can create as many categories as I want (#7), I can organize the queries into logical groups that make finding the right query quick.
I use Insert Query to insert every comment that gets inserted in a manuscript. Even if I do not have the exact query I want in a dataset, I have found that using Insert Query to modify an existing comment or to create a new comment works best for me. Using Insert Query gives me the opportunity to add the revised or new query to my dataset without having to enter it twice.
Remember that the idea is to create the wheel once and reuse it, not recreate it each time. Comments can be time-consuming. Insert Query saves me time, thus making me more profitable; even a savings of just a few seconds per query can add up over time to a significant increase in profit. Additionally, Insert Query reduces the number of embarrassing typing mistakes that are made, thereby making me look more professional.
Sometimes a comment needs to be modified, deleted, or reviewed. The Business of Editing: The AAE Copyediting Roadmap XI discusses how I use Comment Editor when I need to access an already inserted comment.
Richard Adin, An American Editor
Share this:
Like this: