sorting through text with blank fields

I'm trying to pick off fileds from a line to insert them into a database. The problem that I'm having is that there is no delemiters between columns or set amount of spaces. Some columns have blank fields so this causes a problem.

Here is an example
My script would read fieldtwo to be fieldthree instead of blank



here is part of the script where I attempt to sort through the fields

Any help or insight would be greatly appreciated

re: sorting through text with blank fields

are the fields at least fixed lengths? If so you can maybe read the lines/fileds that way, if not, this will be difficult.