This one is really getting on my nerves. The whole point in a CSV is that it uses a unique seperator field.
However, with one that I am working on now, they have commas for the delimiter, and commas in some of the fields.
Does anyone have any ideas on how I could split this string up correctly?
CatalogueCity.co.uk,http://cj.uk.catalogcity.com,12/02/2003 07:49:27 PM,"Hat, The",N/A,"All the animals laugh at Hedgie the hedgehog when a sock becomes caught on his prickles, but it is Hedgie who has the last laugh since it is wintertime and it is keeping him warm. Illustrated in colour by the author.",7732870,Country Book Shop,,,,GBP,0.00,4.50,0.00,yes,http://www.qksrv.net/click-661133-10280697?url=http%3A%2F%2Famos.catalogcity.com%2Fcc.class%2Fcc%3Fpcd%3D5427519%26ccsyn%3D43,http://www.qksrv.net/image-661133-10280697,http://altura.speedera.net/ccimg.catalogcity.com/210000/211200/211247/Products/5427519.jpg,Books/Children's & Teen's Books/Children's Diaries & Journals,,,,,,,,,,,,,,,
I'm stumped
TIA
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
However, with one that I am working on now, they have commas for the delimiter, and commas in some of the fields.
Does anyone have any ideas on how I could split this string up correctly?
CatalogueCity.co.uk,http://cj.uk.catalogcity.com,12/02/2003 07:49:27 PM,"Hat, The",N/A,"All the animals laugh at Hedgie the hedgehog when a sock becomes caught on his prickles, but it is Hedgie who has the last laugh since it is wintertime and it is keeping him warm. Illustrated in colour by the author.",7732870,Country Book Shop,,,,GBP,0.00,4.50,0.00,yes,http://www.qksrv.net/click-661133-10280697?url=http%3A%2F%2Famos.catalogcity.com%2Fcc.class%2Fcc%3Fpcd%3D5427519%26ccsyn%3D43,http://www.qksrv.net/image-661133-10280697,http://altura.speedera.net/ccimg.catalogcity.com/210000/211200/211247/Products/5427519.jpg,Books/Children's & Teen's Books/Children's Diaries & Journals,,,,,,,,,,,,,,,
I'm stumped
TIA
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!