SUBSTRING_INDEX(fieldToSplit, Target Delimiter, Delimiter Count)
Translation: Start at the back of the field (-1) grab all the data until the first ; is encountered, place that in a field called Resources
Using a light rail map as an example, the delimiter “;” are the stations and the -1 vs +1 is the direction of the train