[thelist] Odd Behavior last night with MySQL Server

Rob Smith rob.smith at THERMON.com
Fri Aug 6 11:39:50 CDT 2004

>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

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

Solution? Change the Delimiters. :-)

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

explode on the |

Thanks for unblinding me.


More information about the thelist mailing list