Re: [Tutor] Handling missing fields in a csv file

2009-09-30 Thread Eduardo Vieira
On Tue, Sep 29, 2009 at 3:04 PM, Dave Angel wrote: > Eduardo Vieira wrote: >> >> Hello, I have a csv file, > > a broken csv file >> >>  using the ";" as a delimiter. This file >> contains addresses. My problem is that some fields are missing in some >> rows and I would like to normalize the rows f

Re: [Tutor] Handling missing fields in a csv file

2009-09-29 Thread Dave Angel
Eduardo Vieira wrote: Hello, I have a csv file, a broken csv file using the ";" as a delimiter. This file contains addresses. My problem is that some fields are missing in some rows and I would like to normalize the rows for a smoother import into Excel, for example. Here is an example. This i

[Tutor] Handling missing fields in a csv file

2009-09-28 Thread Eduardo Vieira
Hello, I have a csv file, using the ";" as a delimiter. This file contains addresses. My problem is that some fields are missing in some rows and I would like to normalize the rows for a smoother import into Excel, for example. Here is an example. This is the header: Company;Telephone;Address;Prov;