MySQL finding left-most character and changing the column

[Popcorn Sutton]

I'm having a database contamination issue. I've attached a file of my problem. I'd like to be able to do with Python specifically, but I'm also looking into just using MySQL to complete the task. Check the picture at this point please.

 

Ok, as you can see, I've highlighted the portion that is giving me trouble. What I want to do is make the program find the '$' (left-most character) and shift that row (and all values after that column value) to the right. Any help is appreciated.

 

Thanks!