Your problem descriptions sounds almost as if you are dealing with a file with fixed-width columns. If that is true, use unpack instead of split in order not to miss empty columns that cause the rest of the data to move columns.

Maybe you can show a few lines of the data, and we can tell you a better approach.