[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
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
More information about the thelist
mailing list