{"id":1208,"date":"2021-08-04T12:14:31","date_gmt":"2021-08-04T03:14:31","guid":{"rendered":"https:\/\/www.earce.biz\/?page_id=1208"},"modified":"2022-01-20T01:56:01","modified_gmt":"2022-01-19T16:56:01","slug":"tool-tsv-to-json","status":"publish","type":"page","link":"https:\/\/www.earce.biz\/?page_id=1208","title":{"rendered":"[Tool] TSV 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 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 bufLines = textCSV.split(\"\\n\");\n\t\tvar csvDatas = [];\n\t\tfor (var lineIdx in bufLines) {\n\t\t\tvar csvLineDatas = [];\n\t\t\tvar bufDatas = bufLines[lineIdx].split(\"\\t\");\n\t\t\tfor (var dataIdx in bufDatas) {\n\t\t\t\tcsvLineDatas.push(bufDatas[dataIdx]);\n\t\t\t}\n\t\t\tcsvDatas.push(csvLineDatas);\n\t\t}\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\ttest2\ttest3\n1\t2.1\t3.2E+10\nabc\tdef\tghi\n7\t8\t9\"><\/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-1208","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/pages\/1208","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=1208"}],"version-history":[{"count":8,"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/pages\/1208\/revisions"}],"predecessor-version":[{"id":1492,"href":"https:\/\/www.earce.biz\/index.php?rest_route=\/wp\/v2\/pages\/1208\/revisions\/1492"}],"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=1208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}