{"id":1050,"date":"2015-01-15T16:53:43","date_gmt":"2015-01-15T21:53:43","guid":{"rendered":"http:\/\/www.amibroker.com\/kb\/?p=1050"},"modified":"2015-01-16T16:58:42","modified_gmt":"2015-01-16T21:58:42","slug":"deleting-symbols-with-comma-in-the-name","status":"publish","type":"post","link":"https:\/\/www.amibroker.com\/wordpress\/kb\/2015\/01\/15\/deleting-symbols-with-comma-in-the-name\/","title":{"rendered":"Deleting symbols with comma in the name"},"content":{"rendered":"<p>When importing symbols into the database, we may sometimes encounter situations, when as a result of user-mistake we import erroneous ticker names into our database. This may for example happen when we specify an incorrect column separator in ASCII importer (or use incorrect import definition that does not match the imported file) or when we use input file that contains commas when importing watchlist members using <strong>Symbol->Watchlist->Import<\/strong>.<\/p><p>As a result &#8211; we may end up with a ticker list like this:<\/p><p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2015\/01\/comma1.png\" alt=\"Problematic symbols\" \/><\/p><p>In this case marking the symbols in <strong>Symbols<\/strong> window and using <strong>Delete<\/strong> option from the context menu will not work, because AmiBroker treats the comma as a separator between symbols.<\/p><p>To solve the problem &#8211; with relatively few tickers we can always just open Symbol->Information window and fix the names in there. However &#8211; with a larger group of symbols it will not be very practical.<\/p><p>In such case, in order to delete the incorrect symbols from the database &#8211;  we can use <strong>Symbol->Organize Assignments<\/strong> window, mark the tickers in left-hand-side panel and press <strong>Delete<\/strong> to remove these symbols.<\/p><p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2015\/01\/comma2.png\" alt=\"Removing problematic symbols\" \/><\/p><p>There is also a way to delete the symbols manually from the database folder by removing respective data-files. This requires the following steps:<\/p><ol><li>Exit AmiBroker<li>go to respective subfolder of the database folder (in Windows Explorer)<li>delete data-files for the particular symbols<li>delete broker.master file from the database folder (it stores the symbol list)<li>restart AmiBroker and load the database<\/ol>","protected":false},"excerpt":{"rendered":"<p>When importing symbols into the database, we may sometimes encounter situations, when as a result of user-mistake we import erroneous ticker names into our database. This may for example happen when we specify an incorrect column separator in ASCII importer (or use incorrect import definition that does not match the imported file) or when we [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[54,56,24],"_links":{"self":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1050"}],"collection":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/comments?post=1050"}],"version-history":[{"count":1,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1050\/revisions"}],"predecessor-version":[{"id":1053,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1050\/revisions\/1053"}],"wp:attachment":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/media?parent=1050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/categories?post=1050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/tags?post=1050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}