Title: sqlite3 .import command does not strip spaces from header column names · Issue #2442 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: sqlite3 .import command does not strip spaces from header column names · Issue #2442 · sqlitebrowser/sqlitebrowser
X Title: sqlite3 .import command does not strip spaces from header column names · Issue #2442 · sqlitebrowser/sqlitebrowser
Description: Details for the issue What did you do? Created a sqlite3 script to create NEW database tables using .import command. What did you expect to see? Expected .import command to work exactly like DB Browser GUI import function and strip embed...
Open Graph Description: Details for the issue What did you do? Created a sqlite3 script to create NEW database tables using .import command. What did you expect to see? Expected .import command to work exactly like DB Bro...
X Description: Details for the issue What did you do? Created a sqlite3 script to create NEW database tables using .import command. What did you expect to see? Expected .import command to work exactly like DB Bro...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/2442
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite3 .import command does not strip spaces from header column names","articleBody":"Details for the issue\r\n--------------------\r\n\r\n#### What did you do?\r\nCreated a sqlite3 script to create NEW database tables using .import command. \r\n\r\n#### What did you expect to see?\r\nExpected .import command to work exactly like DB Browser GUI import function and strip embedded spaces from input CSV column names. (e.g., \"PropertyGroup\", \"PropertyAddress\"\r\n\r\n#### What did you see instead?\r\nThe column names of the input CSV file were created WITHOUT stripping embedded spaces. (e.g., \"Property Group\", \"Property Address\"). As the result, all subsequent SQL Select command scripts fail due to undefined column names. \r\n\r\nUseful extra information\r\n-------------------------\r\n> DB4S v3.12.0 [built for x86_64-little_endian-llp64] on Windows 10 (10.0) (winnt/10.0.19041) [x86_64]\r\n> using SQLite Version 3.32.2\r\n> and Qt 5.12.8\r\n> Have tested with SQLite3 versions 3.33 and 3.29","author":{"url":"https://github.com/rgward611","@type":"Person","name":"rgward611"},"datePublished":"2020-10-15T16:14:26Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/2442"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:94863828-74ea-f3ff-2b57-8cc7b1f9a31c |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A67A:1ED1B5:6ECA88:981CC4:6AFD339A |
| html-safe-nonce | a2156079c404e2931469f73a1d6bd1cc95b026ccb2b57243b5f461d1b4bf9a5a |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNjdBOjFFRDFCNTo2RUNBODg6OTgxQ0M0OjZBRkQzMzlBIiwidmlzaXRvcl9pZCI6Ijc0MzY2MTI2MjU0MTIzOTE5NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 7b30d6fa580de9937ce2b3b2311a6c144f8f27876bf25c85c5df892c75116f39 |
| hovercard-subject-tag | issue:722476460 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/2442/issue_layout |
| twitter:image | https://opengraph.githubassets.com/ce8c83d0db77aad48f46e0165856238ca46cbfff7e67ccb0249432c8660dcf98/sqlitebrowser/sqlitebrowser/issues/2442 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/ce8c83d0db77aad48f46e0165856238ca46cbfff7e67ccb0249432c8660dcf98/sqlitebrowser/sqlitebrowser/issues/2442 |
| og:image:alt | Details for the issue What did you do? Created a sqlite3 script to create NEW database tables using .import command. What did you expect to see? Expected .import command to work exactly like DB Bro... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | rgward611 |
| hostname | github.com |
| expected-hostname | github.com |
| None | 065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 941021edf0c2ec58298f4a2c8f27ae507d129c92 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width