Nothing like a weekly challenge to allay the post Inspire blues! I wanted to go a least tools route, so was determined to do all of the parsing in a single formula tool (which also let me rename and assign data types immediately)
Natural instinct is Regex_replace. But like @patrick_digan, noticed this was SLOW. So, used combinations of Left, Right, Substring, Length. Ugly formulas but they work and they're fast!
Only different approach I took was a Make Columns tool instead of the Filter/Join combo. Thanks @NicoleJohnson for introducing me to this tool in a challenge long ago.