If I space out the fields, I think the you'll see that there is no regularity in the number of fields:

C~3453 | Kelly |Horton | Jockey | 27 | $110,250.30
N~3912 | Tom   |Cat                  | $10,345.10
[download]

Given the lack of regularity, you'd need to compensate for that in your split statement assignment, so that Tom's fourth field is equivalent to Kelly's sixth.