How could I extract location name from a text field

EdEvetts - Here a much better "M" way. The trick is the ability to reverse the string in M versus not having that ability in DAX. 

Create a blank query and paste this in:

let
    fnUglyStringBeGone = (MyBigFatZombieString) =>

let

    MyBigFatZombieList = Text.ToList(MyBigFatZombieString),
    MyBigFatZombieCrossEyedList = List.Reverse(MyBigFatZombieList),
    MyBigFatZombieCrossEyedString = Text.Combine(MyBigFatZombieCrossEyedList),
    MyShorterBigFatZombieCrossEyedString = Text.End(MyBigFatZombieCrossEyedString ,Text.Length(MyBigFatZombieCrossEyedString ) - Text.PositionOf(MyBigFatZombieCrossEyedString," ") -1 ),
    MyEvenShorterBigFatZombieCrossEyedString = Text.End(MyShorterBigFatZombieCrossEyedString ,Text.Length(MyShorterBigFatZombieCrossEyedString ) - Text.PositionOf(MyShorterBigFatZombieCrossEyedString ," ") -1 ),
    MyCrossEyedLocationString = Text.Start(MyEvenShorterBigFatZombieCrossEyedString,Text.PositionOf(MyEvenShorterBigFatZombieCrossEyedString," ")),
    MyCrossEyedLocationList = Text.ToList(MyCrossEyedLocationString),
    MyLocationList = List.Reverse(MyCrossEyedLocationList),
    MyLocationString = Text.Combine(MyLocationList)
in

    MyLocationString
in
    fnUglyStringBeGone

I then added this custom column called "Location" to my "StringSadnessAndMisery" table, which only contains a single column [StringSadnessAndMisery].

=fnUglyStringBeGone([StringSadnessAndMisery])

This will work as long as your Location sits in between the 3rd delimiter from the end and the 2nd delimiter from the end. In other words, you always have 2 spaces after the actual location you are trying to identify.