FN-FORUM: CSV Baffler!

date posted 8th March 2006 10:19


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