T&B wrote:
It comes as a CSV or tabbed text file, then into a table in my
database. So, it's in a table in my database, eg:
CREATE TABLE Shopping_Grouped(Aisle TEXT, Product TEXT, Cost REAL)
But the Aisle entries are in records by themselves, and apply to the
subsequent records containing P
nscramble" it.
you will have to figure out how to get your source data into the
SQLite schema you create
It's already in the schema I outlined above. But how to get it into
the schema I want, is my question.
but that should be trivial depending on your programming environment.
Bu
On 3/13/07, T&B <[EMAIL PROTECTED]> wrote:
Hi All,
I come across a fair bit of source data in summary format, where the
one field's values are used as a heading for a group of records for
which it applies. For instance, this shopping list:
Aisle Product Cost
Dairy
Milk
Hi All,
I come across a fair bit of source data in summary format, where the
one field's values are used as a heading for a group of records for
which it applies. For instance, this shopping list:
Aisle Product Cost
Dairy
Milk $2
Cream$1
4 matches
Mail list logo
