So I have a data dump that's supposed to represent a person's height. The data is crap and I'm trying to clean it up. Ultimately, I aim to have a separates fields for feet and inches.

If you work with strings in your Python scripts and you're writing obscure logic to process them, then you need to look into ...