{"id":130,"date":"2019-04-06T20:51:16","date_gmt":"2019-04-06T11:51:16","guid":{"rendered":"https:\/\/www.earce.biz\/?page_id=130"},"modified":"2022-01-20T01:54:38","modified_gmt":"2022-01-19T16:54:38","slug":"tool-csv-to-json","status":"publish","type":"page","link":"https:\/\/www.earce.biz\/?page_id=130","title":{"rendered":"[Tool] CSV to JSON"},"content":{"rendered":"\n<p class=\"has-text-align-center\" style=\"font-size:12px;white-space:nowrap;\">&lt;&lt; This service is not communicating with the server. &gt;&gt;<\/p>\n\n\n\n<script src=\"\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery-csv\/0.8.9\/jquery.csv.min.js\"><\/script>\n<script type=\"text\/javascript\">\njQuery().ready(function($){\n\n$(function(){\n\tsessionStorage.clear();\n\t\n\t$(\"#convT2J\").click( function(e){\n\t\tvar textCSV = $(\"#textCSV\").val();\n\t\tif (textCSV == \"\") {\n\t\t\ttextCSV = $(\"#textCSV\").attr(\"placeholder\");\n\t\t}\n\t\t\n\t\t$('#textJSON').val(\"\");\n\n\t\tvar csvDatas = $.csv.toArrays(textCSV);\n\t\t\n\t\tvar keys = [];\n\t\tvar jsonObj = [];\n\t\tfor (var lineIdx in csvDatas) {\n\t\t\tvar csvLines = csvDatas[lineIdx];\n\t\t\tif (lineIdx == 0) {\n\t\t\t\tkeys = csvLines;\n\t\t\t} else {\n\t\t\t\tvar lineObj = {};\n\t\t\t\tfor (var fieldIdx in keys) {\n\t\t\t\t\tif (fieldIdx < csvLines.length) {\n\t\t\t\t\t\tvar val = csvLines[fieldIdx];\n\t\t\t\t\t\tif (!isNaN(val)) {\n\t\t\t\t\t\t\tlineObj[ keys[fieldIdx] ] = Number(val);\n\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\tlineObj[ keys[fieldIdx] ] = val;\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tjsonObj.push(lineObj);\n\t\t\t}\n\t\t}\n\t\t$('#textJSON').val(JSON.stringify(jsonObj));\n\t});\n});\n\n});\n<\/script>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>CSV Data<\/strong><\/p>\n\n\n\n<textarea id=\"textCSV\" rows=\"5\" cols=\"100\" placeholder=\"test1,test2,test3\n1,2.1,3.2E+10\nabc,def,ghi\n7,8,9\"><\/textarea>\n\n\n\n<div class=\"wp-block-button aligncenter custom-wide-button\">\n<button id=\"convT2J\" class=\"wp-block-button__link has-background has-vivid-cyan-blue-background-color\">Convert<\/button>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>JSON Output<\/strong><\/p>\n\n\n\n<textarea id=\"textJSON\" rows=\"15\" cols=\"100\"><\/textarea>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>CSV Data Convert JSON Output<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":35,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-130","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/pages\/130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.earce.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=130"}],"version-history":[{"count":20,"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/pages\/130\/revisions"}],"predecessor-version":[{"id":1489,"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/pages\/130\/revisions\/1489"}],"up":[{"embeddable":true,"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/pages\/35"}],"wp:attachment":[{"href":"https:\/\/www.earce.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}