{"id":1073,"date":"2023-02-16T08:11:02","date_gmt":"2023-02-16T08:11:02","guid":{"rendered":"https:\/\/www.tools.keywordfinder.us\/?page_id=1073"},"modified":"2023-02-16T08:11:02","modified_gmt":"2023-02-16T08:11:02","slug":"sql-string","status":"publish","type":"page","link":"https:\/\/tools.billionsideas.com\/nl_nl\/sql-string\/","title":{"rendered":"SQL String"},"content":{"rendered":"<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column has-base-3-background-color has-background is-layout-flow wp-block-column-is-layout-flow\">\n<section><h1>Excel To SQL<\/h1>\n          <br>\n            <input class=\"form-check-input\" type=\"checkbox\" value=\"\" id=\"removeLineEndings\">\n            <label class=\"form-check-label\" for=\"defaultCheck1\">\n              Remove lines?\n            <\/label>\n          \n          <textarea class=\"form-control\" id=\"inputTextArea\" placeholder=\"Enter excel data here\"><\/textarea>\n          <div class=\"invalid-feedback\">\n            Please enter Data in the textarea.\n          <\/div><br>\n          <button type=\"submit\" class=\"btn btn-primary my-3\" onclick=\"convertData()\">Convert!<\/button>\n                    <textarea class=\"form-control\" id=\"outputTextArea\" hidden=\"\" rows=\"\"><\/textarea><br><br>\n\n        <\/section>\n\n<script>\nfunction convertData() {\n  var inputTextArea = document.getElementById('inputTextArea');\n  var outputTextArea = document.getElementById('outputTextArea');\n  var removeLineEndings = document.getElementById('removeLineEndings');\n  var inputData = inputTextArea.value;\n  if (inputData != '' && inputData != null) {\n    if (inputTextArea.classList.contains(\"is-invalid\")) {\n        inputTextArea.classList.remove(\"is-invalid\");\n      };\n    inputData = inputData.trim();\n    inputData = inputData.replace(\/\\n\/g, \"', \\n'\");\n    if (inputData.includes(\"\\n'',\")) {\n      inputData = inputData.replace(\/ \\n'',\/g, \"\");\n    }\n    if (removeLineEndings.checked) {\n      inputData = inputData.replace(\/\\n\/g, \"\");\n      }\n    inputData =  \"('\" + inputData + \"')\";\n    outputTextArea.hidden  = false;\n    outputTextArea.value = inputData;\n  } else {\n    inputTextArea.classList.add(\"is-invalid\");\n    outputTextArea.value  = '';\n    outputTextArea.hidden  = true;\n  };\n};\n<\/script>\n\n<style>\nsection{\n         margin-top:60px;\n        width: 100%;\n        max-width: 970px;\n        background-color: #fff;\n        border: 1px solid #ddd;\n        padding: 25px;\n      }\n<\/style>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Excel To SQL Remove lines? Please enter Data in the textarea. Convert!<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","footnotes":""},"class_list":["post-1073","page","type-page","status-publish"],"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"Billions Ideas","author_link":"https:\/\/tools.billionsideas.com\/nl_nl\/author\/loginbillionsideas-com\/"},"comment_info":0,"jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/pages\/1073","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/comments?post=1073"}],"version-history":[{"count":0,"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/pages\/1073\/revisions"}],"wp:attachment":[{"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/media?parent=1073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}