CreativePro Forum

Return to Member Forum

• Author
  Posts
• • August 16, 2019 at 1:45 am #1180773
    Terence McAteer

    Member

    This is an old problem but I’m sifting through a extensive mailing list and all the data has been entered in upper case years ago, and I’ve now been told moving to a new system that only the city name is to remain in upper case. So I’m using change to Title Case in ID (I know it’s not great, TextSoap has a smarter case change but has limitations too). Problem is: O’conner/Mcmurphy should be O’Conner/McMurphy. To achieve this it will have to be a case change script of some sort? Think I’m correct saying GREP won’t do it.

  • August 19, 2019 at 5:06 am #14324270
    Eugene Tyson

    Participant

    I don’t know how it helps but here’s some names in Irish that would be problematic

    Parthalán Ó heachthairn
    Tomás Ághas
    Éinrí Eoin Ó beólláin
    Máire Ní bhraonáin
    Dainéil Ó buachalla

    Should be
    Parthalán Ó hEachthairn
    Tomás Ághas
    Éinrí Eoin Ó Beólláin
    Máire Ní Bhraonáin
    Dainéil Ó Buachalla

    As you can see the Ó heac.. should be Ó hEac… etc.

    Although there is a way to add an All Cap to a GREP style for characters after certain letters and conditions.. there is no way of predicting the pattern as it could be

    MacTyson
    McTyson
    (or in Irish) Mac an Tí (son of Tighe)

    Equally, for your example, it could be

    O’conner/Mcmurphy should be O’Conner/McMurphy
    It could be
    O’Conner or O’ Conner – or it could be McMurphy or MacMurphy

    Each having different spaces/letters between each.

    You would need to build a “Smart Title Case” list with all the different variations – and you may come up against my own name in Irish which would be Eoin Mac an Tí

    Which is a whole different set of problems.

    I don’t see an easy way of doing it.

  • August 19, 2019 at 6:07 am #14324269
    Terence McAteer

    Member

    Thanks Eugene. I’m happy enough with the O’ and no space, ie O’Conner so that would make the query easier and in the North mostly Mc fewer Mac (my own name McAteer don’t think I’ve ever seen a MacAteer :) I came across an article on Carli Jansen’s website about a plugin for ID, Multi-Find/Change (https://www.automatication.com/index.php?id=24) that lets you built queries and batch them together, I’ve got to investigate but there might be a solution with this.

  • August 19, 2019 at 6:36 am #14324268
    Eugene Tyson

    Participant

    Cool – so if you make a Character Style and name it Uppercase surname (or whatever you want)

    And set the case to All Caps

    [img]https://i.ibb.co/WBbnVng/Screen-Shot-2019-08-19-at-14-27-59.png[/img]

    In the Grep style insert a New Grep Style

    [img]https://i.ibb.co/R72DhJS/Screen-Shot-2019-08-19-at-14-35-39.png[/img]

    (?<=O') (?<=Mc') (?<=Mac) for each of them set the Apply Style to your All Caps character style. you can add up to 99 Note - midsentence if you have mackerel - it won't trigger as it's looking for upper case Mac, however, if Mackerel is the start of sentence you'll get MacKerel.

  • August 19, 2019 at 6:37 am #14324267
    Eugene Tyson

    Participant

    My screenshots didn’t work lol

  • August 19, 2019 at 12:04 pm #14324266
    Theunis De Jong

    Member

    I’d advise to steer clear of using GREP styles for what seems a genuine correction of an error. They are hard to correct in case there is an exception, and there is always a chance you have to repurpose your name list for something else, in which case you’d get the uncorrected names back. Even something as innocent as “copy text in InDesign, paste elsewhere” will most likely lose the capitals.

    Since you’re looking at Find/Change anyway, you can do this:

    Find “O’c”, replace with “O’C”, for all likely starting lettersand
    Find “Mcm”, replace with “McM” — again for all starting letters.

    If you only need to do this once, I’d not bother with MultiFind/Change. Do the above two replacements, then search for

    O’

    and

    Mc

    — the final characters here are both lowercase L. This way you’ll find the next uncapitalized name; use that in the next Find/Change. Repeat until nothing more is found.

    And if you fancy a laff, read https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names

• Author
  Posts