{"id":1897,"date":"2013-10-14T02:43:00","date_gmt":"2013-10-13T17:43:00","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1897"},"modified":"2017-01-31T19:43:53","modified_gmt":"2017-01-31T10:43:53","slug":"csv-%ed%8f%ac%eb%a7%b7format%ec%9d%98-%eb%ac%b8%ec%9e%90%ec%97%b4string-%ed%8c%8c%ec%8b%b1parse-parsing","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1897","title":{"rendered":"CSV \ud3ec\ub9f7(Format)\uc758 \ubb38\uc790\uc5f4(String) \ud30c\uc2f1(Parse, Parsing)"},"content":{"rendered":"<p><P>CSV \ud615\ud0dc\ub85c \ub41c \ubb38\uc790\uc5f4\uc744 \ud30c\uc2f1\ud558\uae30 \uc704\ud55c C#\uc5b8\uc5b4\ub85c \uc791\uc131\ub41c \ud568\uc218\uc785\ub2c8\ub2e4. \uc608\uc804\uc5d0 XrGeocoder \ud504\ub85c\uadf8\ub7a8\uc744 \uac1c\ubc1c\ud560\ub54c \uc0ac\uc6a9\ud588\ub358 \ud568\uc218\ub85c.. \ub610 \ub2e4\ub978 \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ub418\uba74\uc11c \ud568\uc218\ub9cc\uc744 \ubd84\ub9ac\ud574 \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4.>\/p><\/p>\n<pre>\r\nprivate List<String> SeperateStringWithComma(String value)\r\n{\r\n    bool inQuotes = false;\r\n    char delim = ',';\r\n    List<String> strings = new List<String>();\r\n\r\n    StringBuilder sb = new StringBuilder();\r\n    foreach (char c in value)\r\n    {\r\n        if (c == '\\'' || c == '\"')\r\n        {\r\n            if (!inQuotes)\r\n                inQuotes = true;\r\n            else\r\n                inQuotes = false;\r\n        }\r\n\r\n        if (c == delim)\r\n        {\r\n            if (!inQuotes)\r\n            {\r\n                strings.Add(sb.Replace(\"'\", string.Empty).Replace(\"\\\"\", string.Empty).ToString());\r\n                sb.Remove(0, sb.Length);\r\n            }\r\n            else\r\n            {\r\n                sb.Append(c);\r\n            }\r\n        }\r\n        else\r\n        {\r\n            sb.Append(c);\r\n        }\r\n    }\r\n\r\n    strings.Add(sb.Replace(\"'\", string.Empty).Replace(\"\\\"\", string.Empty).ToString());\r\n    return strings;\r\n}\r\n<\/pre>\n<p>\uc704\uc758 \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \uc608\uc81c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\r\nString csv = \"2011-01-01,18,2008,\uac1c\uc778,\uc778\ucc9c,\uc911\uad6c,~,2010-12-31,233400,\ub0a8\uc790\";\r\nList<String> values = SeperateStringWithComma(csv);\r\n\r\nint cntValues = values.Count;\r\nfor (int i = 0; i < cntValues; i++)\r\n{\r\n    MessageBox.Show(values[i]);\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>CSV \ud615\ud0dc\ub85c \ub41c \ubb38\uc790\uc5f4\uc744 \ud30c\uc2f1\ud558\uae30 \uc704\ud55c C#\uc5b8\uc5b4\ub85c \uc791\uc131\ub41c \ud568\uc218\uc785\ub2c8\ub2e4. \uc608\uc804\uc5d0 XrGeocoder \ud504\ub85c\uadf8\ub7a8\uc744 \uac1c\ubc1c\ud560\ub54c \uc0ac\uc6a9\ud588\ub358 \ud568\uc218\ub85c.. \ub610 \ub2e4\ub978 \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ub418\uba74\uc11c \ud568\uc218\ub9cc\uc744 \ubd84\ub9ac\ud574 \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4.>\/p> private List SeperateStringWithComma(String value) { bool inQuotes = false; char delim = &#8216;,&#8217;; List strings = new List(); StringBuilder sb = new StringBuilder(); foreach (char c in value) { if (c == &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1897\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;CSV \ud3ec\ub9f7(Format)\uc758 \ubb38\uc790\uc5f4(String) \ud30c\uc2f1(Parse, Parsing)&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[118,8],"tags":[14],"class_list":["post-1897","post","type-post","status-publish","format-standard","hentry","category-csharp","category-programming","tag-c"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1897"}],"version-history":[{"count":3,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1897\/revisions"}],"predecessor-version":[{"id":2948,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1897\/revisions\/2948"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1897"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}