Re: FN-FORUM: CSV Baffler!

date posted 8th March 2006 18:00

Original spreadsheet, save as Text Tab delimited.
Open TextPad or other text editor and replace all commas to space
Then replace all tabs to commas
Save as txt file.
Open Excel editor and go to file > import and select the saved text
file using commas as the delimiters


On 8 Mar 2006 18:21:01 -0000, Bianca Best [EMAIL REMOVED] wr=
ote:
>
> Sam and Julian,
>
> Thanks for all your advice. I'm afraid I'm still really confused. Shoul=
d 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 b=
een
> doing? If so, how do I change what I'm doing to correct it? At the momen=
t 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 outputte=
d
> >> 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
> >
> >
> --
> 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
>
>