{"action":"created","issue":{"url":"https://api.github.com/repos/hadley/readr/issues/322","labels_url":"https://api.github.com/repos/hadley/readr/issues/322/labels{/name}","comments_url":"https://api.github.com/repos/hadley/readr/issues/322/comments","events_url":"https://api.github.com/repos/hadley/readr/issues/322/events","html_url":"https://github.com/hadley/readr/issues/322","id":119159319,"number":322,"title":"parsing failure- read_fwf includes a column of NAs when told to ignore the column?","user":{"login":"ajdamico","id":216807,"avatar_url":"https://avatars.githubusercontent.com/u/216807?v=3","gravatar_id":"","url":"https://api.github.com/users/ajdamico","html_url":"https://github.com/ajdamico","followers_url":"https://api.github.com/users/ajdamico/followers","following_url":"https://api.github.com/users/ajdamico/following{/other_user}","gists_url":"https://api.github.com/users/ajdamico/gists{/gist_id}","starred_url":"https://api.github.com/users/ajdamico/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajdamico/subscriptions","organizations_url":"https://api.github.com/users/ajdamico/orgs","repos_url":"https://api.github.com/users/ajdamico/repos","events_url":"https://api.github.com/users/ajdamico/events{/privacy}","received_events_url":"https://api.github.com/users/ajdamico/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-27T09:19:41Z","updated_at":"2016-01-05T14:24:36Z","closed_at":null,"body":"sorry if i'm misreading something.  thanks!\r\n\r\n\tlibrary(readr)\r\n\tfwf_sample <- system.file(\"extdata/fwf-sample.txt\", package = \"readr\")\r\n\tcat(read_lines(fwf_sample))\r\n\r\n\t# works\r\n\tread_fwf(fwf_sample, fwf_widths(c(2, 5, 3)),col_types='ddd')\r\n\r\n\t# includes a column of NAs because the column contains data even though it was told to skip?\r\n\tread_fwf(fwf_sample, fwf_widths(c(2, 5, 3)),col_types='d-d')\r\n"},"comment":{"url":"https://api.github.com/repos/hadley/readr/issues/comments/169014419","html_url":"https://github.com/hadley/readr/issues/322#issuecomment-169014419","issue_url":"https://api.github.com/repos/hadley/readr/issues/322","id":169014419,"user":{"login":"mlaviolet","id":16492351,"avatar_url":"https://avatars.githubusercontent.com/u/16492351?v=3","gravatar_id":"","url":"https://api.github.com/users/mlaviolet","html_url":"https://github.com/mlaviolet","followers_url":"https://api.github.com/users/mlaviolet/followers","following_url":"https://api.github.com/users/mlaviolet/following{/other_user}","gists_url":"https://api.github.com/users/mlaviolet/gists{/gist_id}","starred_url":"https://api.github.com/users/mlaviolet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mlaviolet/subscriptions","organizations_url":"https://api.github.com/users/mlaviolet/orgs","repos_url":"https://api.github.com/users/mlaviolet/repos","events_url":"https://api.github.com/users/mlaviolet/events{/privacy}","received_events_url":"https://api.github.com/users/mlaviolet/received_events","type":"User","site_admin":false},"created_at":"2016-01-05T14:24:35Z","updated_at":"2016-01-05T14:24:35Z","body":"Hi Anthony, \n\nThanks for your note. I was able to create the design objects for 2011-14 with your \"download all microdata\" script. The queries using dbGetQuery from the \"2011 single-year - analysis examples\" script were quite fast, but when I tried to use the survey functions I got an error:: \n\n> svymean( ~age , brfss.d , na.rm = TRUE ) \nError in checkConnection(dbconnection) : \ncould not find function \"isIdCurrent\" \n\nIt worked once I loaded the RMySQL package , but it was very slow (about five minutes). Does the script need revision, or did I miss something? \n\nIf this helps, the documentation for RMySQL says: \"isIdCurrent will be deprecated in the near future; please use the dbIsValid() generic instead.\" \n\nThanks, \nMike Laviolette \n----- Original Message -----\n\nFrom: \"Anthony Damico\" <notifications@github.com> \nTo: \"hadley/readr\" <readr@noreply.github.com> \nCc: \"mlaviolet\" <statman89@comcast.net> \nSent: Wednesday, December 30, 2015 1:34:58 PM \nSubject: Re: [readr] parsing failure- read_fwf includes a column of NAs when told to ignore the column? (#322) \n\n\n\n( @mlaviolet unrelated to this issue but you can just let this brfss import run overnight and not worry about it. https://github.com/ajdamico/asdfree/tree/master/Behavioral%20Risk%20Factor%20Surveillance%20System ) \n\n— \nReply to this email directly or view it on GitHub . \n\n\n"}}