I’ve been back in the land of screen scrapping this week extracting data from the Game of Thrones wiki and needed to write a regular expression to pull out characters and actors.

Here are some examples of the format of the data: _~text Peter Dinklage as Tyrion Lannister Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer) Filip Lozić as Young Nobleman Morgan C. Jones as a Braavosi captain Adewale Akinnuoye-Agbaje as Malko _~

So the pattern is: _~text as _~

optionally followed by some other text that we’re not interested in.

The output I want to get is: _~text Peter Dinklage, Tyrion Lannister Daniel Naprous, Oznak zo Pahl Filip Lozić, Young Nobleman Morgan C. Jones, a Braavosi captain Adewale Akinnuoye-Agbaje, Malko _~

I started using the 'split' command on the word 'as' but that broke down when I realised some of the characters had the letters 'as' in the middle of their name. So regex it is!

This was my first attempt: _~python import re strings = [ "Peter Dinklage as Tyrion Lannister", "Filip Lozić as Young Nobleman", "Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer)", "Morgan C. Jones as a Braavosi captain", "Adewale Akinnuoye-Agbaje as Malko" ] regex = "() as ([A-Za-z\-'\. ])" for string in strings: print string match = re.match( regex, string) if match is not None: print match.groups() else: print "FAIL" print "" _{~ ~}text Peter Dinklage as Tyrion Lannister ('Peter Dinklage', 'Tyrion Lannister') Filip Lozić as Young Nobleman FAIL Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer) ('Daniel Naprous', 'Oznak zo Pahl') Morgan C. Jones as a Braavosi captain ('Morgan C. Jones', 'a Braavosi captain') Adewale Akinnuoye-Agbaje as Malko ('Adewale Akinnuoye-Agbaje', 'Malko') _~

It works for 4 of the 5 scenarios but now for Filip Lozić. The 'ć' character causes the issue so we need to be able to match foreign characters which the current charset I defined in the regex doesn’t capture.

I came across this Stack Overflow post which said that in some regex libraries you can use '\p{L}' to match all letters. I gave that a try: _~python regex = "() as ([\p{L}\-'\. ])" _~

And then re-ran the script: _~text Peter Dinklage as Tyrion Lannister FAIL Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer) FAIL Filip Lozić as Young Nobleman FAIL Morgan C. Jones as a Braavosi captain FAIL Adewale Akinnuoye-Agbaje as Malko FAIL _~

Hmmm, not sure if I did it wrong or if that isn’t available in Python. I’ll assume the latter but feel free to correct me in the comments and I’ll update the post.

I went search again and found this post which suggested another approach:

Let’s try plugging that in: _~python regex = "() as ([A-Za-z\-'\.^\W\d_ ])" _{~ ~}text Peter Dinklage as Tyrion Lannister ('Peter Dinklage', 'Tyrion Lannister') Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer) ('Daniel Naprous as Oznak zo Pahl(credited', 'Stunt Performer)') Filip Lozić as Young Nobleman ('Filip Lozi\xc4\x87', 'Young Nobleman') Morgan C. Jones as a Braavosi captain ('Morgan C. Jones', 'a Braavosi captain') Adewale Akinnuoye-Agbaje as Malko ('Adewale Akinnuoye-Agbaje', 'Malko') _~

So that’s fixed Filip but now Daniel Naprous is being incorrectly parsed.

For Attempt #4 I decided to try excluding what I don’t want instead: _~python regex = "() as ([^0-9\(])" _{~ ~}text Peter Dinklage as Tyrion Lannister ('Peter Dinklage', 'Tyrion Lannister') Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer) ('Daniel Naprous', 'Oznak zo Pahl') Filip Lozić as Young Nobleman ('Filip Lozi\xc4\x87', 'Young Nobleman') Morgan C. Jones as a Braavosi captain ('Morgan C. Jones', 'a Braavosi captain') Adewale Akinnuoye-Agbaje as Malko ('Adewale Akinnuoye-Agbaje', 'Malko') _~

That does the job but has exposed my lack of regex skillz. If you know a better way let me know in the comments.