Dealing with a badly formatted CSV file?

You can't anticipate where the badly formed file will be badly formed. The next time the user gives you the file it can be in the middle of the file.

I am not sure what you mean by "bad format". But if the separators are consistent and number of columns is the same across the lines, just use LOAD DATA INFILE MySQL statement. You can specify '|' as field separator there.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.