{"id":550,"date":"2018-03-27T17:15:19","date_gmt":"2018-03-27T15:15:19","guid":{"rendered":"http:\/\/xml-buddy.com\/xmltribune\/?p=550"},"modified":"2021-11-10T21:33:11","modified_gmt":"2021-11-10T20:33:11","slug":"pretty-print-and-remove-whitespace-for-large-json-data","status":"publish","type":"post","link":"https:\/\/www.xml-buddy.com\/xmltribune\/pretty-print-and-remove-whitespace-for-large-json-data\/","title":{"rendered":"Pretty-print and remove whitespace for large JSON data"},"content":{"rendered":"<p>What do you do if you need to compact a JSON document but the file has more than 400 MB and 20 Million lines?\u00a0Or the other way around, you have a large document and it is impossible to read because it has no formatting? So you need a JSON editor which can do two things for you. The editor can open and view really large text files and it needs to know how to format or compact your JSON data. Luckily, JSONBuddy can do both for you.<\/p>\n<p>Simply select your large JSON document in the built-in File Explorer window. You can also select multiple files if you need to do this for several documents:<\/p>\n<div id=\"attachment_554\" style=\"width: 635px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/xml-buddy.com\/xmltribune\/wp-content\/uploads\/2018\/03\/json-buddy-remove-whitespace-file-explorer.png\"><img aria-describedby=\"caption-attachment-554\" loading=\"lazy\" class=\"size-large wp-image-554\" src=\"http:\/\/xml-buddy.com\/xmltribune\/wp-content\/uploads\/2018\/03\/json-buddy-remove-whitespace-file-explorer-1024x661.png\" alt=\"Remove whitespace from big JSON data\" width=\"625\" height=\"403\" srcset=\"https:\/\/www.xml-buddy.com\/xmltribune\/wp-content\/uploads\/2018\/03\/json-buddy-remove-whitespace-file-explorer-1024x661.png 1024w, https:\/\/www.xml-buddy.com\/xmltribune\/wp-content\/uploads\/2018\/03\/json-buddy-remove-whitespace-file-explorer-300x194.png 300w, https:\/\/www.xml-buddy.com\/xmltribune\/wp-content\/uploads\/2018\/03\/json-buddy-remove-whitespace-file-explorer-768x495.png 768w, https:\/\/www.xml-buddy.com\/xmltribune\/wp-content\/uploads\/2018\/03\/json-buddy-remove-whitespace-file-explorer-624x403.png 624w, https:\/\/www.xml-buddy.com\/xmltribune\/wp-content\/uploads\/2018\/03\/json-buddy-remove-whitespace-file-explorer.png 1426w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><p id=\"caption-attachment-554\" class=\"wp-caption-text\">Remove whitespace from big JSON data<\/p><\/div>\n<p>Run either the &#8220;Pretty-print JSON&#8221; or &#8220;Remove whitespace from JSON&#8221; command from the JSON menu. JSONBuddy will save the output document next to the original JSON with a new file name. You will still have the original content as before on your disk.<\/p>\n<p>Of course, you can run both commands on the current document in the JSON editor.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What do you do if you need to compact a JSON document but the file has more than 400 MB and 20 Million lines?\u00a0Or the other way around, you have a large document and it is impossible to read because it has no formatting? So you need a JSON editor which can do two things for you. The editor can&#8230; <a href=\"https:\/\/www.xml-buddy.com\/xmltribune\/pretty-print-and-remove-whitespace-for-large-json-data\/\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[77,4],"tags":[85,67,86],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/posts\/550"}],"collection":[{"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/comments?post=550"}],"version-history":[{"count":4,"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/posts\/550\/revisions"}],"predecessor-version":[{"id":557,"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/posts\/550\/revisions\/557"}],"wp:attachment":[{"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/media?parent=550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/categories?post=550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xml-buddy.com\/xmltribune\/wp-json\/wp\/v2\/tags?post=550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}