Excel and SQL Server) when reading CSV you always have to enter separator char, “has header row” etc. The goal with CsvQuery has always been to detect everything automatically, usually (e.g. Yeah, the header detection needs improvement. Unrelated, but I found out you can concatenate with SQLite using || instead of +. “No, it is numbers, I shall help you and remove the leading zeros from the east coast and any Canada or UK postals will be unrecognizable or cause an error. I would think it would return 6 if it’s just yanking the numbers out of the data.īack in the day the MS csv text driver gave me all kinds of trouble with zip codes. I’m curious because this works (even with the euro sign in the data):īut summing the “ArtDesc” column returns 0.0. Otherwise you get generic col0, I’m curious if you determine data types in the plugin, or does sqlite make it’s own guess? How does it know what type to make a column when it imports the csv into SQL Server? For my 32bit NPP, it seems like if the first row is all encapsulated, it becomes the column names. I tried your second example and my column names were col0 - col1, not the first row of data like you said. I tried your first example and encapsulated the column names in quotes and they turned into column names.
0 Comments
Leave a Reply. |