Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

--empty-null option when importing CSV #563

Closed
simonw opened this issue Jul 3, 2023 · 1 comment
Closed

--empty-null option when importing CSV #563

simonw opened this issue Jul 3, 2023 · 1 comment
Labels
cli-tool enhancement New feature or request

Comments

@simonw
Copy link
Owner

simonw commented Jul 3, 2023

CSV files with empty cells in (which come through as the empty string) are common and a bit gross.

Having an option that means "and if it's an empty string store null instead) would be cool.

I brainstormed name options here https://chat.openai.com/share/c947b738-ee7d-419c-af90-bc84e90987da

@simonw simonw added enhancement New feature or request cli-tool labels Jul 3, 2023
@simonw simonw closed this as completed in f7af238 Jul 3, 2023
@simonw
Copy link
Owner Author

simonw commented Jul 3, 2023

Documentation at the bottom of this section: https://sqlite-utils.datasette.io/en/latest/cli.html#inserting-csv-or-tsv-data

simonw added a commit that referenced this issue Jul 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
cli-tool enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant