Re: FN-FORUM: CSV Baffler!

date posted 8th March 2006 17:39

Sam and Julian,

Thanks for all your advice. I'm afraid I'm still really confused. Should I
be editing my original excel spreadsheet? Or, do I open the spreadsheet in
StarOffice, resave as .csv and edit the filter settings then, as I have been
doing? If so, how do I change what I'm doing to correct it? At the moment I
put | in the field delimiter and " in the text delimiter. Where should I
change what I'm doing? Sorry, I need spoon feeding I know!

Thank for all your help.

Bianca

----- Original Message -----
From: "Julian Voelcker" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Wednesday, March 08, 2006 3:33 PM
Subject: Re: FN-FORUM: CSV Baffler!


>
> Hi Sam,
>
>> 1. You are using "|" for the separation not '|' not a problem as long as
>> the
>> script is looking for that.
>
> As I thought, Bianca needs to search for "," and replace it with "|" - I
> suspect that in the original email the inverted comma (') was just used to
> quote what she was using.
>
>> 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.
>
> I suspect that might not be an issue, most import routines should be OK
> with
> that - is there an end of record character?
> --
>
> Cheers,
>
> Julian Voelcker,
> Cheltenham, Glos.
> T: 01285 821 910
> M: 07971 540 362
> MSN: [EMAIL REMOVED]
> Skype: julianvoelcker
>
>
>
> --
> 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
>
>