{"action":"created","issue":{"url":"https://api.github.com/repos/SIB-Colombia/data-quality-open-refine/issues/15","repository_url":"https://api.github.com/repos/SIB-Colombia/data-quality-open-refine","labels_url":"https://api.github.com/repos/SIB-Colombia/data-quality-open-refine/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/SIB-Colombia/data-quality-open-refine/issues/15/comments","events_url":"https://api.github.com/repos/SIB-Colombia/data-quality-open-refine/issues/15/events","html_url":"https://github.com/SIB-Colombia/data-quality-open-refine/issues/15","id":354497038,"node_id":"MDU6SXNzdWUzNTQ0OTcwMzg=","number":15,"title":"VALIDACIÓN TAXONÓMICA | remover caractéres no imprimibles en scientificName","user":{"login":"camiplata","id":5700527,"node_id":"MDQ6VXNlcjU3MDA1Mjc=","avatar_url":"https://avatars0.githubusercontent.com/u/5700527?v=4","gravatar_id":"","url":"https://api.github.com/users/camiplata","html_url":"https://github.com/camiplata","followers_url":"https://api.github.com/users/camiplata/followers","following_url":"https://api.github.com/users/camiplata/following{/other_user}","gists_url":"https://api.github.com/users/camiplata/gists{/gist_id}","starred_url":"https://api.github.com/users/camiplata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camiplata/subscriptions","organizations_url":"https://api.github.com/users/camiplata/orgs","repos_url":"https://api.github.com/users/camiplata/repos","events_url":"https://api.github.com/users/camiplata/events{/privacy}","received_events_url":"https://api.github.com/users/camiplata/received_events","type":"User","site_admin":false},"labels":[{"id":996521025,"node_id":"MDU6TGFiZWw5OTY1MjEwMjU=","url":"https://api.github.com/repos/SIB-Colombia/data-quality-open-refine/labels/bug","name":"bug","color":"d73a4a","default":true},{"id":996521027,"node_id":"MDU6TGFiZWw5OTY1MjEwMjc=","url":"https://api.github.com/repos/SIB-Colombia/data-quality-open-refine/labels/enhancement","name":"enhancement","color":"a2eeef","default":true}],"state":"open","locked":false,"assignee":{"login":"camiplata","id":5700527,"node_id":"MDQ6VXNlcjU3MDA1Mjc=","avatar_url":"https://avatars0.githubusercontent.com/u/5700527?v=4","gravatar_id":"","url":"https://api.github.com/users/camiplata","html_url":"https://github.com/camiplata","followers_url":"https://api.github.com/users/camiplata/followers","following_url":"https://api.github.com/users/camiplata/following{/other_user}","gists_url":"https://api.github.com/users/camiplata/gists{/gist_id}","starred_url":"https://api.github.com/users/camiplata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camiplata/subscriptions","organizations_url":"https://api.github.com/users/camiplata/orgs","repos_url":"https://api.github.com/users/camiplata/repos","events_url":"https://api.github.com/users/camiplata/events{/privacy}","received_events_url":"https://api.github.com/users/camiplata/received_events","type":"User","site_admin":false},"assignees":[{"login":"camiplata","id":5700527,"node_id":"MDQ6VXNlcjU3MDA1Mjc=","avatar_url":"https://avatars0.githubusercontent.com/u/5700527?v=4","gravatar_id":"","url":"https://api.github.com/users/camiplata","html_url":"https://github.com/camiplata","followers_url":"https://api.github.com/users/camiplata/followers","following_url":"https://api.github.com/users/camiplata/following{/other_user}","gists_url":"https://api.github.com/users/camiplata/gists{/gist_id}","starred_url":"https://api.github.com/users/camiplata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camiplata/subscriptions","organizations_url":"https://api.github.com/users/camiplata/orgs","repos_url":"https://api.github.com/users/camiplata/repos","events_url":"https://api.github.com/users/camiplata/events{/privacy}","received_events_url":"https://api.github.com/users/camiplata/received_events","type":"User","site_admin":false},{"login":"RicardoOrtizG","id":15789737,"node_id":"MDQ6VXNlcjE1Nzg5NzM3","avatar_url":"https://avatars3.githubusercontent.com/u/15789737?v=4","gravatar_id":"","url":"https://api.github.com/users/RicardoOrtizG","html_url":"https://github.com/RicardoOrtizG","followers_url":"https://api.github.com/users/RicardoOrtizG/followers","following_url":"https://api.github.com/users/RicardoOrtizG/following{/other_user}","gists_url":"https://api.github.com/users/RicardoOrtizG/gists{/gist_id}","starred_url":"https://api.github.com/users/RicardoOrtizG/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RicardoOrtizG/subscriptions","organizations_url":"https://api.github.com/users/RicardoOrtizG/orgs","repos_url":"https://api.github.com/users/RicardoOrtizG/repos","events_url":"https://api.github.com/users/RicardoOrtizG/events{/privacy}","received_events_url":"https://api.github.com/users/RicardoOrtizG/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2018-08-27T22:11:15Z","updated_at":"2018-08-28T13:51:31Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Algunos nombres científicos no se están validando adecuadamente ya que el separador entre palabras no corresponde a un espacio en este caso es posible incorporar al expresión \r\n\r\nvalue.replace(/\\W+/,' ')\r\n\\W, meaning any non-word character, sin embargo hay que tener cuidado ya que los paréntesis y puntos desaparecerian dificultando la validación.\r\n\r\nHay que evaluar la mejor ruta para manejar TODOS los caracteres no imprimibles que son siempre problemáticos.\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/SIB-Colombia/data-quality-open-refine/issues/comments/416591739","html_url":"https://github.com/SIB-Colombia/data-quality-open-refine/issues/15#issuecomment-416591739","issue_url":"https://api.github.com/repos/SIB-Colombia/data-quality-open-refine/issues/15","id":416591739,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNjU5MTczOQ==","user":{"login":"camiplata","id":5700527,"node_id":"MDQ6VXNlcjU3MDA1Mjc=","avatar_url":"https://avatars0.githubusercontent.com/u/5700527?v=4","gravatar_id":"","url":"https://api.github.com/users/camiplata","html_url":"https://github.com/camiplata","followers_url":"https://api.github.com/users/camiplata/followers","following_url":"https://api.github.com/users/camiplata/following{/other_user}","gists_url":"https://api.github.com/users/camiplata/gists{/gist_id}","starred_url":"https://api.github.com/users/camiplata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camiplata/subscriptions","organizations_url":"https://api.github.com/users/camiplata/orgs","repos_url":"https://api.github.com/users/camiplata/repos","events_url":"https://api.github.com/users/camiplata/events{/privacy}","received_events_url":"https://api.github.com/users/camiplata/received_events","type":"User","site_admin":false},"created_at":"2018-08-28T13:51:31Z","updated_at":"2018-08-28T13:51:31Z","author_association":"CONTRIBUTOR","body":"Una solución más elegante en la documentación de Open Refine\r\n\r\nTrim whitespace from beginning and end of values\r\n  value.trim()\r\nor if you have non-breaking spaces &nbsp on both ends then you might try this instead:\r\n\r\n  split(escape(value,'xml'),\"&#160;\")[0]\r\nIf you don't know what kind of whitespace character is present, and they are not removed using 'trim' you can create a new column using:\r\n\r\nvalue.escape(\"javascript\")\r\nThis should reveal the types of whitespace that are in the original column, and allow you to target them for removal."}}
{"actor":{"display_login":"camiplata"}}