Re: FN-FORUM: CSV Baffler!

date posted 8th March 2006 14:51

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