{"id":329,"date":"2018-02-14T15:15:47","date_gmt":"2018-02-14T15:15:47","guid":{"rendered":"https:\/\/career0to1.wordpress.com\/?p=329"},"modified":"2018-02-15T05:54:25","modified_gmt":"2018-02-15T05:54:25","slug":"csv-splitter","status":"publish","type":"post","link":"https:\/\/career0to1.com\/?p=329","title":{"rendered":"CSV\u00a0 Splitter"},"content":{"rendered":"<div id=\"dslc-theme-content\"><div id=\"dslc-theme-content-inner\"><p><span style=\"font-weight:bold;font-style:italic;font-family:Calibri;font-size:11pt;color:black;\">CSV\u00a0 Splitter<\/span><span style=\"font-family:Calibri;font-size:11pt;color:black;\"> &#8211; <\/span><a href=\"http:\/\/www.fxfisherman.com\/forums\/forex-metatrader\/tools-utilities\/75-csv-splitter-divide-large-csv-files.html\"><span style=\"font-family:Calibri;font-size:11pt;\">http:\/\/www.fxfisherman.com\/forums\/forex-metatrader\/tools-utilities\/75-csv-splitter-divide-large-csv-files.html<\/span><\/a><span style=\"font-family:Calibri;font-size:11pt;color:black;\">.\u00a0 Google earth can only deal with 2400 points.\u00a0 If you are going to have more than that, you need this tool.\u00a0 Sydney had ~90,000 water meters in Florida.<\/span><\/p>\n<ul style=\"margin-left:.375in;direction:ltr;unicode-bidi:embed;margin-top:0;margin-bottom:0;\" type=\"disc\">\n<li style=\"margin-top:0;margin-bottom:0;vertical-align:middle;\"><span style=\"font-weight:bold;font-style:italic;font-family:Calibri;font-size:11pt;color:black;\">HINT<\/span><span style=\"font-family:Calibri;font-size:11pt;color:black;\">:\u00a0 A bunch of addresses might get kicked out.\u00a0 If you see a pattern of mistakes, fix them in Excel.\u00a0 <\/span>\n<ul style=\"margin-left:.375in;direction:ltr;unicode-bidi:embed;margin-top:0;margin-bottom:0;\" type=\"disc\">\n<li style=\"margin-top:0;margin-bottom:0;vertical-align:middle;\"><span style=\"font-family:Calibri;font-size:11pt;color:black;\">Example: Maybe your records say &#8220;TRC&#8221; every time that google earth would like them to say &#8220;Terrace&#8221;<\/span><\/li>\n<li style=\"margin-top:0;margin-bottom:0;vertical-align:middle;\"><span style=\"font-family:Calibri;font-size:11pt;color:black;\">Example 2: Maybe your database thinks it&#8217;s &#8220;Mc Nab Street&#8221; but google thinks it&#8217;s &#8220;McNab Street&#8221;<\/span><\/li>\n<li style=\"margin-top:0;margin-bottom:0;vertical-align:middle;\"><span style=\"font-family:Calibri;font-size:11pt;color:black;\">You are so !!!SMART!!! you can probably figure out what I am trying to say by now\u2026<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"margin-top:0;margin-bottom:0;vertical-align:middle;\"><span style=\"font-weight:bold;font-style:italic;font-family:Calibri;font-size:11pt;color:black;\">HINT 2<\/span><span style=\"font-family:Calibri;font-size:11pt;color:black;\">: Save as KML, not KMZ because fusion tables kind of hates KMZ.<\/span><\/li>\n<\/ul>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>CSV\u00a0 Splitter &#8211; http:\/\/www.fxfisherman.com\/forums\/forex-metatrader\/tools-utilities\/75-csv-splitter-divide-large-csv-files.html.\u00a0 Google earth can only deal with 2400 points.\u00a0 If you are going to have more than that, you need this tool.\u00a0 Sydney had ~90,000 water meters in Florida. HINT:\u00a0 A bunch of addresses might get kicked out.\u00a0 If you see a pattern of mistakes, fix them &hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[5],"tags":[9],"_links":{"self":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/329"}],"collection":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=329"}],"version-history":[{"count":1,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/329\/revisions"}],"predecessor-version":[{"id":433,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/329\/revisions\/433"}],"wp:attachment":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}