"Jungle Boogie" wrote...
Dear Igor,
--------------------------------------------
From: Igor Tandetnik <i...@tandetnik.org>
Sent: Mon, 22 Sep 2014 16:34:18 -0400
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite max arguments assistance
Just as I thought. You are storing your values as text - not as numbers -
and
comparing them accordingly, in alphabetical order.
Sorry, I'm not certain I know the answer to this as I don't generate the
data.
Opening the csv file in Excel, I did have to change the transaction_amount
column from "general" to "number". I think your assumptions are correct,
though. I'll see if I can look at the values in the other database.
I know the data is generated from a different database and a file is
created,
portalusemonthly.csv that's sent to a location where I can get it?
Is there anything I can do post export from the other database to change
the
values correctly?
you can open it back in Excel and do a search replace for $ for "" to delete
the $ in that column or through out the excel.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users