{"id":1861,"date":"2014-11-07T13:18:23","date_gmt":"2014-11-07T21:18:23","guid":{"rendered":"http:\/\/thelawlers.com\/Blognosticator\/?p=1861"},"modified":"2023-03-10T17:32:52","modified_gmt":"2023-03-11T01:32:52","slug":"more-in-my-grepping-drama","status":"publish","type":"post","link":"https:\/\/thelawlers.com\/Blognosticator\/?p=1861","title":{"rendered":"More in my GREPping drama"},"content":{"rendered":"

\"Blognosticator<\/a><\/p>\n

In past blogs I have expressed my love\u00a0for the GREP functions in InDesign. GREP is not only functional, but for me it\u2019s a lot of fun.<\/p>\n

I enjoy working with strings of text, manipulating things en masse to cause changes that would otherwise take too long.<\/p>\n

An example I have written about in the past is that of reversing names in a list from last name-first to first name-first. I have written a handful of GREP search instructions to do this, and none of them is completely perfect. That is still the case, but I discovered a couple of new GREP commands in InDesign that are very useful, and I want to share my success with you.<\/p>\n

The pattern of text that I work with is my class lists, which are sent to me by the university at the beginning of each quarter. These come with an overload of information, and I have to filter-out only the names to make a roll sheet for the first day of class.<\/p>\n

The patterns look like this:<\/p>\n

7 Bauer, Marcus Desmond mbauer09 GRC Freshman 3 Enrolled No<\/em><\/p>\n

The numeral is the number of the student in the list, then last name, first name, middle name (or not), e-mail address, the student\u2019s major, class level, the number after that is the units of the class, and then their enrollment status (always \u201cEnrolled\u201d) and whether the student has flagged his or her information to be kept private. When I look at the text, I look for patterns<\/em> that I can search for:<\/p>\n

\"String<\/a><\/p>\n

I only need the second and third elements of all of this data, so GREP can help me accomplish this in two ways: 1, It strips off the unnecessary data, and 2, it reverses the last name and the first name.<\/p>\n

The implementation of GREP in InDesign is pretty good, but it varies slightly from the more \u201cpure\u201d GREP that is found in UNIX and in some text editing environments. But, that\u2019s OK with me, because InDesign is where I work most often with text, and it\u2019s very helpful to be able to use it there.<\/p>\n

\"GREP<\/a><\/p>\n

This is the anatomy of my GREP search string in InDesign. It uses the commands that are new to me: the at-the-beginning-of-the-paragraph, and \u201cfind a word.\u201d<\/span><\/em><\/p>\n

The \u201cnew\u201d functions that I have discovered are the \u201cat the beginning of a paragraph\u201d command, which is a simple caret at the beginning of the command string, and the \u201cfind a word\u201d command, which I use twice in this search.<\/p>\n

\\w+ is the command to find a word. Words are defined as characters in any order, in any case, not separated by non-alphabetical characters (which you will see in my example here). Word does\u00a0find number strings*<\/span> and the underscore, but no other characters.<\/p>\n

So, to find the second and third data elements (both words), I search for (\\w+) twice, and I get both words.<\/p>\n

They\u2019re separated by a comma and a space in the text, so I put those characters in between, and that works also.<\/p>\n

To capture the numbers at the beginning of the paragraph (and no others), I use the command ^(\\d+ ) which finds any digit, one or more times, followed by a space. I put this inside of parentheses to pass it to a memory space called $1. Later I will not use that memory space, but I need to capture it for the short term.<\/p>\n

I then search for \u201ca word\u201d and pass those words to memory positions $2 and $3 for the last and first names, respectfully.<\/p>\n

After the student\u2019s names there is all that other information that I don\u2019t want. I use GREP\u2019s command for finding any character (this includes letters, numbers, figures \u2013 anything) followed by a standard carriage return. This gets rid of everything after the student\u2019s first name.<\/p>\n

Once I have all that, I put the first and last name back in the opposite order, and I\u2019m done.<\/p>\n

\"Replace<\/a><\/p>\n

This is the replace string for the search above. It\u2019s very simple: put the content of Memory 3 followed by the content of Memory 2 back on the line, separated by a space, and followed by a standard carriage return. The comma after the last name is automatically dropped because it was not inside the parentheses in the search string.<\/span><\/em><\/p>\n

In my earlier method for this, my search criteria usually failed when a capital letter showed up in a name, like DuPont. This new method works for those kind of names. But, it doesn\u2019t work for names that have spaces in them, nor for words with hyphens.<\/p>\n

In the past I had to fix those names by hand, and I still have to do that, but with fewer names now.<\/p>\n

\"Class<\/a><\/p>\n

This is the list as I receive it from the university.<\/span><\/em><\/p>\n

\"Class<\/a><\/p>\n

\u2026and this is the same list with potential problems highlighted in red. In my previous GREPping dramas, I have had to fix all of the lines marked in red.<\/span><\/em><\/p>\n

By using the new search criteria, I can fix most of these, but not all:<\/p>\n

\"Names<\/a><\/p>\n

Notice that only two of the four potential problems were not processed correctly: those with spaces in the last name, and one with a hyphenated last name.<\/span><\/em><\/p>\n

It\u2019s easy to fix those that are not processed by the search string, and it only takes a few seconds.<\/p>\n

* An addendum (November 9, 2014):<\/span>\u00a0Though it doesn\u2019t make any difference in performance, it is possible to search for three \u201cwords\u201d \u2013 the first being the serial number, the second being the student\u2019s last name, and the third being his or her first name. The search string looks like this:<\/p>\n

^(\\w+) (\\w+), (\\w+) (.+~b)<\/span><\/p>\n

The result is identical.<\/p>\n","protected":false},"excerpt":{"rendered":"

In past blogs I have expressed my love\u00a0for the GREP functions in InDesign. GREP is not only functional, but for me it\u2019s a lot of fun. I enjoy working with strings of text, manipulating things en masse to cause changes … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,26],"tags":[64,444,330,446,447,445],"class_list":["post-1861","post","type-post","status-publish","format-standard","hentry","category-printing-and-printing-processes","category-typography-2","tag-brian-lawler","tag-grep","tag-grep-in-indesign","tag-indesign-find-and-change","tag-indesign-typograpy","tag-pattern-searching-in-indesign"],"_links":{"self":[{"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=\/wp\/v2\/posts\/1861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1861"}],"version-history":[{"count":4,"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=\/wp\/v2\/posts\/1861\/revisions"}],"predecessor-version":[{"id":3581,"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=\/wp\/v2\/posts\/1861\/revisions\/3581"}],"wp:attachment":[{"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thelawlers.com\/Blognosticator\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}