1. Rename .csv to .txt2. Excel will now ask for column treatment on import3.
Specify the problem column(s) as "text" not "general"
There are other problems with csv recognizing text as numbers. I had a column
with content, say 123D4. Excel recognized the old FORTRAN double precision
format and
"CSV import deletes /leading/ zeroes on text fields" excel does this.
Quite difficult to stop it from doing so.
On Fri, Jul 13, 2018 at 6:52 AM, R Smith wrote:
> I believe your subject should read: "CSV import deletes /leading/ zeroes on
> text fields" - Your trailing Zero is in tact.
>
> And
Click on the link at the bottom of every post to the list, including this one,
then scroll to the bottom of the page to find how to unsubscribe.
Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I believe your subject should read: "CSV import deletes /leading/ zeroes
on text fields" - Your trailing Zero is in tact.
And your declaration is wrong - in SQL the column name is first, then
the Type, so it must be:
CREATE TABLE foo(bar TEXT NOT NULL);
Opening the csv file in Excel or CALC
On 12 Jul 2018, at 9:47am, Simon Leo Hafner wrote:
> create table foo (
> text bar not null
> );
Should be
bar TEXT NOT NULL
I'm not sure how your line is being parsed, but I can understand it thinking
you have not set a column type.
Simon.
To reproduce:
create table foo (
text bar not null
);
.import test.csv foo
select * from foo;
With test.csv:
test
01230
Expected result:
test
01230
Actual result:
test
1230
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
On 12 Jul 2018, at 19:11, Richard Hipp wrote:
> When network filesystems do not follow the usual semantics of a
> filesystem, it can cause problems.
>
> That said, Firefox and Chrome have for many years stored lots of stuff
> in SQLite database files in the users home directory, which is often a
With Richards comment, the only additional thing I'd weigh in on is what
your remote file server is doing with the physical file. Virus scanners
can interfere with the usual operation of your program, and can cause
certain things to happen. Because the OS you're running your software on
is told
On 7/12/18, dmp wrote:
>
> I use a dump
> in my interface which I used with diff to compare changes in my
> personal expense database. This was to insure changes introduced in work
> on the interface were not screwing things up. Very helpful to insure
> your not introducing bugs.
I am glad that
On 7/12/18, Robert M. Münch wrote:
>
> We now saw two crash reports with „Database disk I/O error“ when a
> transaction was closed with „END“. Is this a known problem when having
> sqlite files on a network share?
>
When network filesystems do not follow the usual semantics of a
filesystem, it
Randall wrote:
> My wishlist is:
> (o) Allow humans to view the contents of a DB without custom tools.
If what is meant here is a generic tool that opens/views any particular
file format, db context here, then there are tools including
the generic db gui that I have been working on for years.
>
Hi,
Context: Users of our app can define a working directory where sqlite files are
stored. This can be a network share. The files are only used by one user at the
time.
We now saw two crash reports with „Database disk I/O error“ when a transaction
was closed with „END“. Is this a known
Your email to the list went through ok.
As far as the list goes, only admin can see the whole list of who's subscribed.
Otherwise you can only see who posts messages. An example as to why is that
just recently we had an issue of a spam bot sending junk to anyone who posted
to the list. If it
Hello. I am a newcommer to programming tools like GIT and everything. I
have programming skills but i don't know how mailing lists works. I want to
submit my own quesion.
Is this being read by all members? Please, if someone read this, send a
reply to me.
Also, i want to have see portfolio of
This query will work fine. You could also do something like:
UPDATE tips
SET totalUsed = totalUsed - (SELECT MIN(totalUsed) - 1 FROM tips);
which would include the extra 1 (the new base) in the scalar subquery.
The expression (SELECT MIN(totalUsed) FROM tips) is not correlated with the
On 12 Jul 2018, at 8:30am, Cecil Westerhof wrote:
> I am not quit happy with this. Would it be better to split it in two
> queries and feed the result of the first to the second?
I would guess that it will run faster. How much faster depends on how many
rows there are in the table. Naturally
2018-07-12 9:30 GMT+02:00 Cecil Westerhof :
> A few tables have a not completely apt named column totalUsed.
>
> It is used to see which records are more used as other records and give
> the less used records a bigger chance of being selected. When the numbers
> become high I do something like:
>
A few tables have a not completely apt named column totalUsed.
It is used to see which records are more used as other records and give the
less used records a bigger chance of being selected. When the numbers
become high I do something like:
UPDATE tips
SET totalUsed = totalUsed - (SELECT
19 matches
Mail list logo