RE: FN-FORUM: CSV Baffler!

date posted 8th March 2006 13:04


Looking at your csv, there are three things that look wrong.

1. You are using "|" for the separation not '|' not a problem as long as the
script is looking for that.

2. If a field value is blank then you are only putting a | as a delimiter
not "|" which if the script is just looking for "|" then it will miss these
fields out.

2. You seem to have records with extra carriage returns being outputted to
the file within a record, if your script reads one line as one record then
it will not be able to recognise the data.

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: "Bianca Best" [EMAIL REMOVED]
> To: [EMAIL REMOVED]
> Sent: Wednesday, March 08, 2006 10:45 AM
> Subject: Re: FN-FORUM: CSV Baffler!
>
>
> > Thanks Sam,
> >
> > Here's my wierd data. I think you're right about the '
> thing. So, if
> > it's
> > to do with commas in my text, should I replace all my commas with a
> > straight
> > comma type thing?? Where's this on my keyboard? Sorry, I'm
> really out of
> > my
> > depth here.
> >
> > Thanks,
> >
> > Bianca
> >
> >
> > The Poetry Studio
> > 1 Marlborough Mews
> > Court Road
> > Banstead
> > Surrey SM7 2GJ
> >
> > 01737 357900
> > www.thepoetrystudio.co.uk
> > ----- Original Message -----
> > From: "Sam Morgan" [EMAIL REMOVED]
> > To: [EMAIL REMOVED]
> > Sent: Wednesday, March 08, 2006 11:10 AM
> > Subject: RE: FN-FORUM: CSV Baffler!
> >
> >
> >>
> >> 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
> >>>
> >>>
> >> --
> >> 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
> >>
> >>