The same way you did for 349 and 2019
SELECT
Transfer,
Left(Transfer, InStr(Transfer, "/") - 1) AS Part1,
Mid(Transfer, InStr(Transfer, "/") + 1, InStr(Transfer, " ") - InStr(Transfer, "/") - 1) AS Part2,
Mid(Transfer, InStr(Transfer, " ") + 1, InStrRev(Transfer, "/") -...