Oh jolly, now I see the problem
.
Your file problem isn't solvable because the format isn't well defined.
Maybe it is but you didn't provide the definition.
The problem is that a computer can't know the difference between a person's name and a company name. Eventually, for a database to be a database, something needs to be delimited by something. This isn't the case here.
Did you export the file from a database? From which? How did you export it?
I can't imagine the export went ok.