{"action":"opened","issue":{"url":"https://api.github.com/repos/shtiper/phpscript/issues/7","labels_url":"https://api.github.com/repos/shtiper/phpscript/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/shtiper/phpscript/issues/7/comments","events_url":"https://api.github.com/repos/shtiper/phpscript/issues/7/events","html_url":"https://github.com/shtiper/phpscript/issues/7","id":119996357,"number":7,"title":"remove dashes (-) in phone numbers in CONTACTS table","user":{"login":"shtiper","id":16025606,"avatar_url":"https://avatars.githubusercontent.com/u/16025606?v=3","gravatar_id":"","url":"https://api.github.com/users/shtiper","html_url":"https://github.com/shtiper","followers_url":"https://api.github.com/users/shtiper/followers","following_url":"https://api.github.com/users/shtiper/following{/other_user}","gists_url":"https://api.github.com/users/shtiper/gists{/gist_id}","starred_url":"https://api.github.com/users/shtiper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shtiper/subscriptions","organizations_url":"https://api.github.com/users/shtiper/orgs","repos_url":"https://api.github.com/users/shtiper/repos","events_url":"https://api.github.com/users/shtiper/events{/privacy}","received_events_url":"https://api.github.com/users/shtiper/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-12-02T17:38:17Z","updated_at":"2015-12-02T17:38:17Z","closed_at":null,"body":"anyway we can put a scrap rule in the script to remove all dashes (\"-\") in all phone numbers before importing into the CONTACTS table?  (business_phone, business_fax, mobile_phone columns)\r\n\r\nso phones would be in the same format as owners_phone_num in JOBs table for easier search and look up.\r\n![screen shot 2015-12-02 at 12 30 49 pm](https://cloud.githubusercontent.com/assets/16025606/11538781/72831e20-98f1-11e5-995f-ac858cf454ea.png)\r\n![screen shot 2015-12-02 at 12 31 18 pm](https://cloud.githubusercontent.com/assets/16025606/11538782/73a625e0-98f1-11e5-9ebb-b9709dc53518.png)\r\n\r\n"}}