{"action":"created","issue":{"url":"https://api.github.com/repos/wireservice/csvkit/issues/301","repository_url":"https://api.github.com/repos/wireservice/csvkit","labels_url":"https://api.github.com/repos/wireservice/csvkit/issues/301/labels{/name}","comments_url":"https://api.github.com/repos/wireservice/csvkit/issues/301/comments","events_url":"https://api.github.com/repos/wireservice/csvkit/issues/301/events","html_url":"https://github.com/wireservice/csvkit/pull/301","id":39832538,"number":301,"title":"in2csv: allowed user to change output format of csv and added --decimal-delimiter flag","user":{"login":"yakxxx","id":1457092,"avatar_url":"https://avatars.githubusercontent.com/u/1457092?v=3","gravatar_id":"","url":"https://api.github.com/users/yakxxx","html_url":"https://github.com/yakxxx","followers_url":"https://api.github.com/users/yakxxx/followers","following_url":"https://api.github.com/users/yakxxx/following{/other_user}","gists_url":"https://api.github.com/users/yakxxx/gists{/gist_id}","starred_url":"https://api.github.com/users/yakxxx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yakxxx/subscriptions","organizations_url":"https://api.github.com/users/yakxxx/orgs","repos_url":"https://api.github.com/users/yakxxx/repos","events_url":"https://api.github.com/users/yakxxx/events{/privacy}","received_events_url":"https://api.github.com/users/yakxxx/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2014-08-08T15:13:52Z","updated_at":"2016-12-08T14:07:15Z","closed_at":"2014-09-01T20:36:57Z","pull_request":{"url":"https://api.github.com/repos/wireservice/csvkit/pulls/301","html_url":"https://github.com/wireservice/csvkit/pull/301","diff_url":"https://github.com/wireservice/csvkit/pull/301.diff","patch_url":"https://github.com/wireservice/csvkit/pull/301.patch"},"body":"When decimal separator in Windows is set to comma Excel will generate CSV with comma-separated floats and semicolon-separated fields. Sometimes external software relies on this behavior and accepts only CSVs with comma as decimal delimiter and semicolon as field delimiter for specific locale settings.\n\nTo enable csvkit users to generate CSVs for such software I added flags to change settings of output csv and also added custom flag to replace '.' in floats.\n"},"comment":{"url":"https://api.github.com/repos/wireservice/csvkit/issues/comments/265747619","html_url":"https://github.com/wireservice/csvkit/pull/301#issuecomment-265747619","issue_url":"https://api.github.com/repos/wireservice/csvkit/issues/301","id":265747619,"user":{"login":"dalcolmo","id":6770249,"avatar_url":"https://avatars.githubusercontent.com/u/6770249?v=3","gravatar_id":"","url":"https://api.github.com/users/dalcolmo","html_url":"https://github.com/dalcolmo","followers_url":"https://api.github.com/users/dalcolmo/followers","following_url":"https://api.github.com/users/dalcolmo/following{/other_user}","gists_url":"https://api.github.com/users/dalcolmo/gists{/gist_id}","starred_url":"https://api.github.com/users/dalcolmo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dalcolmo/subscriptions","organizations_url":"https://api.github.com/users/dalcolmo/orgs","repos_url":"https://api.github.com/users/dalcolmo/repos","events_url":"https://api.github.com/users/dalcolmo/events{/privacy}","received_events_url":"https://api.github.com/users/dalcolmo/received_events","type":"User","site_admin":false},"created_at":"2016-12-08T14:07:15Z","updated_at":"2016-12-08T14:07:15Z","body":"Not yet, as I am still using csvkit 0.9.1, but I am worried the behaviour is going to change by using the agate library in version 1.0.0 (which I haven't tried yet). Version 0.9.1 writes CSV files always in a standardized way, but the agate library writes CSV files in a format **depending on the locale**, for example using commas instead of decimal points and semicolons as line separator with the locale set to \"DE\". When using the library within Python, I can simply set the locale to \"C\" and I get always the \"standard\" behaviour, but when using the csvkit command line utilities I am not sure what is going to happen in version 1.0, as I do not see any switch to reset the locale.\r\n\r\nIt is paramount for backward compatibility of our tools, which we built upon csvkit, that the CSV file format (item separator = \",\" and the decimal separator = \".\") remains unchanged no matter which locale the individual user has.\r\n\r\n- Josef"}}
{"actor":{"display_login":"dalcolmo"}}