Split just isn't going to work if you can have missing columns. If split returns 3 columns how are you going to guess which one is missing?.

The data you posted looks like it's a fixed length format, so you'd be better using unpack