Skip to main content
B
British Stunt Register
Participating Frequently
November 4, 2023
Question

Use GREP to create a new line and header style after the last occurance of a words only once

  • November 4, 2023
  • 3 replies
  • 1256 views

Hi 

I wonder if someone can help I have a list of skills. And because of the short comings of the data collection method I had to put them into one column in a datamerge. 

I'm trying to use GREP to find just the last occurance of a skill (only once) "Stunt Coordinator" or "Second Unit Director" or "Stunt Performer" or "Doubled For" to then add a return and give it a header title skill. Like in the photo attached. In the photo I'm testing it on just one word but I'm not having any luck. Can someone help please.

Thank you

    This topic has been closed for replies.

    3 replies

    P
    Community Expert
    Peter KahrelCommunity Expert
    Community Expert
    November 5, 2023

    @British Stunt Register 

     

    James -- It's still not very clear what the before and after states are. You said 'The Before for a performer' -- where is that performer? What to do with them? And 'For a Performer I'd like and for lack of a screenshot I'm just using text . . .' isn't very clear either.

     

    As Mark requested earlier, please provide literal examples of the before and after states.

     

    Though I don't understand what exactly you're after, it looks not simply like (re-)formatting, which can be handled by search-and-replace, but a proper transformation, for which you'll need a script.

     

    P.

      B
      British Stunt RegisterAuthor
      Participating Frequently
      November 5, 2023

      Thank you sorry about that, here is what Im' looking to achieve: 

      Like what @m1b stated I'm trying to search for roles:

      1. Search for certain words in a given story or document, eg, the grep

      Role: (Stunt Double|Second Unit Director|Second Unit Director & Stunt Coordinator|Actor|Character)

       2. Pick the last one in the story and add a new paragraph after its paragraph and apply the green sub-heading/rule below paragraph style.

      3. The text of the new paragraph style is dependent on the text found in the grep, but not the same, eg "Stunt Double" —> "Doubled For".

       

      Here is the raw data:
      I can search and replace the "Production Name:" and the "Doubled For/Character Name:" like previous comments suggested, thank you.

      Production Name: The Crown S6, Role: Additional Stunt Coordinator, Doubled For/Character Name:
      Production Name: The Larkins S2, Role: Additional Stunt Coordinator, Doubled For/Character Name:
      Production Name: Kidnapped, Role: Additional Stunt Coordinator, Doubled For/Character Name:
      Production Name: Meg2: The Trench, Role: Stunt Performer, Doubled For/Character Name:
      Production Name: Andor S2, Role: Stunt Performer, Doubled For/Character Name:
      Production Name: Heads of State, Role: Stunt Performer, Doubled For/Character Name:
      Production Name: Wicked, Role: Stunt Performer, Doubled For/Character Name:
      Production Name: Blitz, Role: Stunt Performer, Doubled For/Character Name:
      Production Name: Red Eye, Role: Stunt Double, Doubled For/Character Name: Lesley Sharp
      Production Name: Murder They Hope, Role: Stunt Double, Doubled For/Character Name: Annette Badland
      Production Name: Apartment 7A, Role: Stunt Double, Doubled For/Character Name: Tina Gray
      Production Name: Dinner with the Parents, Role: Stunt Double, Doubled For/Character Name: Carol Kane
      Production Name: Doc Martin, Role: Stunt Double, Doubled For/Character Name: Beth Goddard
      Production Name: Challenge, Role: Character, Doubled For/Character Name: Stunt Neighbour
      Production Name: A Thousand Blows, Role: Character, Doubled For/Character Name: Head Cook
      Production Name: Boat Story, Role: Stunt Double, Doubled For/Character Name: Joanna Scanlan
      Production Name: Titanic, Role: Character, Doubled For/Character Name: Drowned Woman Floating
      Production Name: Braveheart, Role: Stunt Performer, Doubled For/Character Name:
      Production Name: My House in Umbria, Role: Stunt Double, Doubled For/Character Name: Maggie Smith
      Production Name: Shaun of the Dead, Role: Character, Doubled For/Character Name: Fainting woman
      Production Name: Eastern Promises, Role: Stunt Double, Doubled For/Character Name: Naomi Watts
      Production Name: Hyde Park on Hudson, Role: Stunt Double, Doubled For/Character Name: Laura Linney
      Production Name: 44 Inch Chest, Role: Stunt Double, Doubled For/Character Name: Joanne Whalley
      Production Name: Harry Potter 4 - 8, Role: Stunt Double, Doubled For/Character Name: Helena Bonham Carter
      Production Name: Red 2, Role: Stunt Double, Doubled For/Character Name: Helen Mirren
      Production Name: White Girl, Role: Stunt Coordinator, Doubled For/Character Name:
      Production Name: Skyfall, Role: Stunt Performer, Doubled For/Character Name:
      Production Name: Fast & Furious 6, Role: Stunt Double, Doubled For/Character Name: Michelle Rodriguez
      Production Name: Mary Poppins Returns, Role: Stunt Double, Doubled For/Character Name: Julie Walters
      Production Name: Rocketman, Role: Character, Doubled For/Character Name: Old Pub Woman

      Thank you

      Robert at ID-Tasker
      Robert at ID-Tasker
      Legend
      November 5, 2023

      @British Stunt Register 

       

      So you want to get your screenshot from the raw text at the end of your message? 

       

      GREP will never to that - as you need to rebuild the whole text = custom script. 

       

      ... 

       

      If you've access to Excel or something similar - you could do this semi-automatically - convert ","  and ":" to tabs, copy to Excel, sort by 4th column...

      But still more processing needed = custom script. 

       

      Robert at ID-Tasker
      Robert at ID-Tasker
      Legend
      November 5, 2023

      If you work on a PC - is it one-time job or do you have to do it more often? 

       

      B
      British Stunt RegisterAuthor
      Participating Frequently
      November 5, 2023

      I'm on a Mac and it is a one time job. Although I will have to do it again once these proofs are checked.

      m1b
      Community Expert
      m1bCommunity Expert
      Community Expert
      November 4, 2023

      Hi @British Stunt Register, can you show a screenshot of what it should look like afterwards?

      - Mark

      B
      British Stunt RegisterAuthor
      Participating Frequently
      November 4, 2023

      It would search for Stunt Double then create a header and have the name of the show and then the actor name

       

      m1b
      Community Expert
      m1bCommunity Expert
      Community Expert
      November 4, 2023

      Hi @British Stunt Register, sorry that's not quite what I was asking for. It would be easiest for anyone reading here if you can show a simple before and after situation. So we can see a representative example of what you are starting with, and then what you expect to have after the help you are asking for.

       

      From your screenshot I can guess something like the following:

       

      1. You search for certain words in a given story or document, eg, the grep

      Role: (Stunt Double|Second Unit Director|Some Other Role)

       

       2. You pick the last one in the story and add a new paragraph after its paragraph and apply the green sub-heading/rule below paragraph style.

       

      3. The text of the new paragraph style is dependent on the text found in the grep, but not the same, eg "Stunt Double" —> "Doubled For".

       

      Is that close? It helps to be as explicit as possible, because the easier you make it for someone to understand, the more chance of someone being able to help you.

      - Mark

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices