Substring – Not limiting yourself to the ends of the data

SUBSTRING(fieldToSplit, Starting Character, How Many Characters)

Because this data is consistently structured in the beginning of the record, we can pull the first 3 fields out with SUBSTRING