 | | Re: CSV delimiters
|
|
There exists (in CPAN) a Text-CSV perl module. From its documentation: This module is based upon a working definition of CSV format which may not be the most general. 1 Allowable characters within a CSV field include 0x09 (tab) and the inclusive (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
|
| |
| | Re: CSV delimiters
|
|
(...) I remember looking for this about a year ago, and I came across something that looked very standardish. If I remember right, it's really silly. You don't actually escape things. Fields are comma separated, and optionally surrounded by (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
|
| |
| | Re: CSV delimiters
|
|
(...) I think there are a variety of CSV-to-HTML-table converters floating around that you can download -- I saw at least 3 earlier while searching before posting. You'd probably want to look for one that somehow auto-sensed whether quotes were (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
|
| |
| | RE: CSV delimiters
|
|
(...) I agree. I was trying to hack an Excel file into some usable html, and those "" made it nearly impossible for me to do search and replaces to get valid html without messing it up in other places. --Bram Bram Lambrecht BXL34@po.cwru.edu (URL) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
|
| |
| | Re: CSV delimiters
|
|
(...) Eeek -- shame on me -- did I just say "it's" when I meant "its"? Anyway, I forgot to say: The idea of escaping quotes is *bizarre* in the first place. IMHO, there shouldn't *be* any closing double-quote character on a field once it has already (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
|
| |
| | Re: CSV delimiters
|
|
(...) I hate it too. IIRC, Excel uses "" instead of \" for an escaped " -- but I could be wrong. I just remember hating it once when I looked at it. :) One nice thing, though, is that Excel can import tab-delimited text, so that's it's saving grace. (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
|
| |
| | RE: CSV delimiters
|
|
(...) Sorry, I can't help. And I hate the way Excel outputs in plain text. But since it's 2:30 in the morning, I'll make useless comments. Sounds like you're working on the question I asked...augh, and I just entered all the sets manually. Oh well, (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
|
| |
| | CSV delimiters
|
|
Is there any "official" or "reasonably standardized format" for CSV (_C_omma _S_eparated _V_alue) data? I guess it's pretty obvious, mostly, but how are the delimiter characters typically encoded (specifically: comma, double-quote, and newline)? In (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
|
| |
| | Re: compiled / searchable parts database with links to the set guide?
|
|
(...) This is great! Todd: How about linking the element count in the set guide to the corresponding inventory page on dands site? KL (...) (24 years ago, 22-Sep-00, to lugnet.db.inv, lugnet.admin.database)
|
| |
| | Re: compiled / searchable parts database with links to the set guide?
|
|
(...) the biggest thing everyone should agree on is the nameing convention... We used partsref and partid for ours, which seemed to be the most complete and easy to use convention... All the rest is really easy to transform, from one format to (...) (24 years ago, 22-Sep-00, to lugnet.db.inv, lugnet.admin.database)
|
| |
| | Re: compiled / searchable parts database with links to the set guide?
|
|
(...) we will have three distinct implementations of the same functionality. I think we *really* should throw our efforts together to create *one* implementation (which could coincidentally be hosted on lugnet). But then again, just about everyone (...) (24 years ago, 22-Sep-00, to lugnet.db.inv, lugnet.admin.database)
|
| |
| | Re: compiled / searchable parts database with links to the set guide?
|
|
(...) well, we started creating something similar, but didn't import any external data yet: (URL) (24 years ago, 22-Sep-00, to lugnet.db.inv, lugnet.admin.database)
|
| |
| | compiled / searchable parts database with links to the set guide?
|
|
Hi, Did anyone compile the inventories that were posted here in a machine-readable format, possibly even integrating it with the data from set inventories at lugnet? I'd really like to continue the work of Tim Vattima. Wouldn't it be wonderful if (...) (24 years ago, 22-Sep-00, to lugnet.db.inv, lugnet.admin.database)
|
| |
| | Re: 9731 Vision Command release date?
|
|
(...) Hmm, yes, that's right. Fixed. Originally, it was announced (with set number) back in 1999, and I think that's when it was added to the DB, and I guess LEGO decided to delay it, or else we misunderstood the intended release date. --Todd (24 years ago, 20-Sep-00, to lugnet.admin.database)
|
| |
| | 9731 Vision Command release date?
|
|
Hi, The guide shows the release date for 9731 Vision Command as 1999. Isn't that a 2000 set? Regards, Hakan (24 years ago, 20-Sep-00, to lugnet.admin.database)
|
| |
| | Re: LEGO Set Lists (was: Re: Announcing new set database)
|
|
(...) I'll start entering my complete set collection soon! -Frank (24 years ago, 20-Sep-00, to lugnet.admin.database)
|
| |
| | Re: LEGO Set Lists (was: Re: Announcing new set database)
|
|
(...) Yep!! Extremely useful..:-) At least an "input set list page" where we can input our sets by simply clicking on check boxes or such. Something like summary pages of set searches. I think including the input functionality to the current (...) (24 years ago, 20-Sep-00, to lugnet.admin.database)
|
| |
| | Re: LEGO Set Lists (was: Re: Announcing new set database)
|
|
(...) also, (though Jenn already did everything by hand), import-from-CSV? :) Dan (24 years ago, 20-Sep-00, to lugnet.admin.database)
|
| |
| | Re: LEGO Set Lists (was: Re: Announcing new set database)
|
|
(...) I could! I could!!! :) :) Dan (24 years ago, 20-Sep-00, to lugnet.admin.database)
|
| |
| | Re: LEGO Set Lists (was: Re: Announcing new set database)
|
|
(...) Throw me $100K and I can guarantee that. :-) (...) Could you make use of an export-as-CSV (or tab-separated text) feature? (...) Looking forward to that, ya! (...) This is just a tiny step in the right direction! :) --Todd (24 years ago, 20-Sep-00, to lugnet.admin.database)
|
