Taifun wrote:
these 3 rows look fine, you have to look for a quote and you will find the row, which results in that issue
see again your error message Syntax Error: quote in unquoted cell
I solved that problem many hours ago by doing a binary search for the offending line, and then fixed the
code that generates the file so it wouldn't put quotes in there anymore. However, I wanted to solve the
general problem: how to keep the app from choking should a differentspurious character get in there?
That's how I knew it was a double quote that caused the problem: I found it the hard way. That's why it
would be nice if list from csv table would at least give offending line number in the error message.
Of course, if I'd know what the error message meant "quote in unquoted cell" I might have figured this
out faster. I'm not as swift as I used to be.
What is the benefit of the additional conversion from text file to TinyDB?
TinyDB is your data store, you said, you like to achieve persistence...
OK, TinyDB is same as a perl hash. I understand that it give me persistence. But I'm not sure how I would
us it in this instance, except to store the entire list of entries in there under a single key value. Or perhaps store
all the entries for a single state under the key for that state (NJ -> New Jersey list, NY -> New York list, etc).
But that seems like more work for no benefit that I can see.
it probably helps to do some tutorials to learn the basics...
Despite my rocky start in this thread, I'm actually an experience (retired) developer. So I'm familiar with
various databases (sql, Berkeley, perl hash, etc).
btw. your for each loop is not necessary, the split block already converts the file into a list, see also the documentation
just use these blocks instead
set global listLocations to split (get text, \n)
Yes, oops, that's obvious now that you mention it. Another vestigial bit left over from using "list from csv table".
I'll try that and see what happens.