Dear Simon, -------------------------------------------- From: Simon Slavin <[email protected]> Sent: Mon, 22 Sep 2014 22:22:00 +0100 To: General Discussion of SQLite Database <[email protected]> Subject: Re: [sqlite] sqlite max arguments assistance > > > On 22 Sep 2014, at 10:02pm, Jungle Boogie <[email protected]> wrote: > >> Is there anything I can do post export from the other database to change the >> values correctly? > > You need to strip the dollar signs off at some stage. > > Ideally you can do it in the CSV file before you import that into SQLite. > > Alternatively you may be able to do the import into SQLite then issue the > following command: > > UPDATE august SET transaction_amount = REPLACE(transaction_amount,'$','') > > before you do your SELECT. >
Actually, none of the fields have the dollar sign, that's my mistake. Can I tell sqlite pre or post import of the csv that the field is number or will it always take it as it? > Simon. -- inum: 883510009027723 sip: [email protected] xmpp: [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
