On 10 Sep 2014, at 3:45am, Carlos A. Gorricho (HGSAS)
wrote:
> The problem was a field with a very long blank string, something like 40
> space-characters.
Was this value correctly delimited with quotes, or was it just 40 spaces
between two commas separating the
Dear all,
A brief update on how I managed to solve the problem...thank you all for
you remarks and comments, since these were instrumental in the solution.
Indeed sqlite versions had to do a lot with the problem, where 3.8 can
handle csv imports, not without some glitches. I had to go in circles
Humour us and paste the first 4 lines or so of your CSV text here
On 2014/09/05 04:17, Carlos A. Gorricho (HGSAS) wrote:
So, any ideas on how to solve this issue will be more than welcome. I have
tried several shortcuts...none works.
Latest was to install an Ubuntu 14.04 Virtual Machine
I get similar results on OS X 10.9.4 if I try to use the version of SQLite
supplied with the operating system (3.7.13) to import a CSV.
The simple ".mode csv" and ".import tab1" method works if I run the
copy of SQLite 3.8.5 I built myself from the source code, or if I use the Mac
OS X
Carlos A. Gorricho (HGSAS) wrote on Friday, September 05, 2014 4:17 AM
>So, any ideas on how to solve this issue will be more than welcome. I have
>tried several shortcuts...none works.
>Latest was to install an Ubuntu 14.04 Virtual Machine on my Mac, via Parallels
>software.
>
Maybe line
So, any ideas on how to solve this issue will be more than welcome. I have
tried several shortcuts...none works.
Latest was to install an Ubuntu 14.04 Virtual Machine on my Mac, via
Parallels software.
Downloaded sqlite de Linux way:
$ sudo apt-get install sqlite3
Ran the CSV .import protocol
​When I start sqlite double clicking the icon in the Mac Applications
folder:
Last login: Wed Sep 3 10:13:32 on ttys000
HEPTAGON-GROUP-SAS:~ carlosgorricho$ /Applications/sqlite3 ; exit;
SQLite version 3.8.5 2014-06-04 14:06:34
Enter ".help" for usage hints.
Connected to a *transient
On 3 Sep 2014, at 1:51pm, Richard Hipp wrote:
> What version of SQLite is installed?
Or rather, when you start the shell tool 'sqlite3' what version does it report
itself as ?
Simon.
___
sqlite-users mailing list
8 matches
Mail list logo