search

wireservice / csvkit

A suite of utilities for converting to and working with CSV, the king of tabular file formats.
https://csvkit.readthedocs.io
MIT License
6.03k stars 603 forks source link

Phone numbers are incorrectly converted to floats #1143

Closed dylan-chong closed 3 years ago

dylan-chong commented 3 years ago 
> printf "phone\n+1234567891" | csvsql --query 'select * from stdin'
phone
1234567891.0
jpmckinney commented 3 years ago

Use -I

> printf "phone\n+1234567891" | csvsql -I --query 'select * from stdin'
phone
+1234567891