|
|
 |
Re: FN-FORUM: CSV Baffler!
date posted 8th March 2006 13:10
Thanks Sam, these sound like great words of wisdom. Will absorb and
hopefully correct. I'll keep you posted. Thank you.
Bianca
----- Original Message -----
From: "Sam Morgan" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Wednesday, March 08, 2006 1:47 PM
Subject: RE: FN-FORUM: CSV Baffler!
>
>
> 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
>> >>
>> >>
> --
> 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
>
> |
|
|
