[thelist] Odd Behavior last night with MySQL Server

[Rob Smith]

>I retract my previous hasty red-herring comment.  
>Hassan is right about the number of columns.

And you are too. The fact that:

47,"Home","Books","Audiobooks","Movies, Music & Entertainment",""

When exploded on , yields

47
"Home"
"Books"
"Audiobooks"
"Movies
Music & Entertainment"

(ignoring the rest causing 5 columns to "appear" when 6 are in fact present)

My next problem becomes how do you escape the comma's without escaping the
delimiters? 

Solution? Change the Delimiters. :-)

Find and replace all..
."Home with |"Home 
"," with "|"

explode on the |

Thanks for unblinding me.

Rob