RE: FN-FORUM: CSV Baffler!

date posted 8th March 2006 10:28

Show us the csv so we can see.

Make sure you are using the correct ' as there is ' and ` which will be
treated differently by any conversion script.

Regards

Sam Morgan

WiredEyes / WebClickGo
tel (Uk): +44 (0)20 7100 2178 / tel (Italy): +39 070 766 242
fax (uk): 0871 433 2278 / fax (Italy): 070 330 9939
web : www.wiredeyes.com / www.webclickgo.com
----
umop ap!sdn w,! aw dlaH



> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On
> Behalf Of Bianca Best
> Sent: 08 March 2006 12:01
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: CSV Baffler!
>
>
>
> Hi,
>
> I'm desperately trying to manage my ecommerce site and have
> come across a
> bizarre error I simply can't solve.
>
> My product spreadsheet is built in excel. I open this document in
> StarOffice8 to then resave as a .csv file. I edit filter settings to
> replace ',' with '|'. This .csv file should then contain all
> my date broken
> into fields by '|'. Instead, it's splitting it at every
> single comma found
> within any text, meaning it's become an endless strem of meaningless
> gobbledeygook!! My webmaster does exactly the same thing on
> his pc and the
> .csv file comes back as a perfect list of row by row products
> split with
> '|'s. There must be some setting on my pc that is corrupting
> this process.
> Has anyone got ANY idea what it could be??????? I'm utterly
> stumped. Help
> please!
>
> Thanks in advance.
>
> Bianca
>
> The Poetry Studio
> 1 Marlborough Mews
> Court Road
> Banstead
> Surrey SM7 2GJ
>
> 01737 357900
> www.thepoetrystudio.co.uk
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>