CSV File

[raouleduke]

I am getting this CSV, Excel File that looks like this:

26642	12/2/2003	29140		SUSPENSION
			03CHZ	                ALIGN FT. END

The first line is the record but if there are multiple values for each column it gets put into the next line.

What I need to do is import this into MySQL, and have it be one record, and each one of these values separated by a space.

Thanks in advance.

[AstroTeg]

There's no easy way of doing it besides processing the file line by line and determining if the 2nd line belongs to the first line. It could get really ugly. Although its not impossible...