Posted by kenoli on 03/03/07 17:08

On Mar 2, 6:08 am, "Steve" <no....@example.com> wrote:

> you do realize this is a shitty format for csv...right?

I at least suspected as much. This format is what Excel puts out and
I have been trying to understand regular expressions well enought to
correct it in text wrangler. As you can tell, I am learning this as I
go along. I can see that the two scripts above also change the format
though I wasn't able to exactly figure out how the syntax works. I
did try.

>
> christ kenoli, you have two examples of how to do this. the least you could
> do is try to output some debugging info in the code.

I wasn't aware of the debugging output I could request and will put
some time into figuring out how to do this. The earlier suggestions
on this are helpful.

and, if you can't use
> that to help yourself figure it out, you could at least post the line's data
> here so we aren't guessing.
>
> my recommendation: don't quit your day job.

Don't worry, I barely have a day job to quit. I am doing this for
some community projects I am involved in. A friend and I are involved
in a project to help communities develop a vision for themselves and
then put together the resources to make it happen. We work hand to
mouth and one of the reasons I am doing this is that we can't afford
to hire anyone else to do it. There is no question I an a novice. I
never expect to be a professional, though I would love to learn enough
to make it all go more easily and quickly.

The assistance that people on this list have given is hugely valuable
and appreciated. I'm sorry if my own ignorance makes my questions
incomplete or foollish. I think I'm getting better. At any rate, my
code needs less and less debugging. It is an achievement for me when
I can type out a dozen lines of code and they actually work the first
time!

I ended up taking the novice's way out here and downloaded a
demonstration copy of Navicat. It made importing the records very
easy.

--Kenoli

[Back to original message]