I see a post https://stackoverflow.com/questions/67607384/split-an-array-of-nested-json-objects-using-jq, the poster gave an example JSON file: { "storeId": "1412", "templateCheck": [ { "rom": 37, "updateDate": "2021-05-09 07:53:17", "lhb": "2021-05-09 06:32:41", ... Read more
Author Archives: Shiji Pan
Convert text book to audio book
If you want to convert text books to audio books, you can try TTS Batch Converter. For example, we have a book “Pride and Prejudice”, we want to convert it to an audio book. For avoiding too big audio file (.mp3 or .wav), we split the book into chapters. And then we convert these ... Read more
Split text book into chapters and store it in TXT files
If you want to split a TXT book info chapters, you can try Big Text File Splitter. In the splitting form, set “Split By” to “Symbol”. Since this text book’s chapters are start with “Chapter”, so we set “Start With” to “Chapter”, ... Read more
Format multiple JSON files into one CSV for NTFS on OpenSea
If you want to format multiple JSON files into one CSV for NTFS on OpenSea, you can try Data File Converter, just in a few mouse clicks. 1. Open Data File Converter, select “Files” – “JSON”, “File” – “CSV”. 2. Choose OpenSea JSON ... Read more
Convert nested JSON to CSV
I see a post Convert nested JSON to CSV or table, the poster have JSON data like this: menu1.json {"menu": { "id": "file", "value": "File", "popup": { "menuitem": [ {"value": "New", "onclick": "CreateNewDoc()"}, {"value": "Open", "onclick": "OpenDoc()"}, ... Read more
Convert XML attributes to CSV columns
I see a post How to convert XML into CSV using XSL, the poster has a test XML like this: <Tester author="Name" id="16384543"> <insert tableName="sampletable"> <column name="id" valueNumeric="2"/> <column name="name" value="kathy"/> <column ... Read more
Convert KML to CSV
If you want to convert KML files to CSV files, you can try Data File Converter. An sample KML (Keyhole Markup Language) file like this: <?xml version="1.0" encoding="UTF-8"?> <kml xmlns="http://www.opengis.net/kml/2.2"> <Placemark> <name>Simple ... Read more
Convert JSON with attributes to CSV
I want to convert some NFT metadata JSON files to CSV for opensea. JSON data like this: { "name": "5", "description": "", "external_url": "", "image": "5.png", "attributes": [ { "trait_type": "Background", "value": "DOT-6" }, { "trait_type": ... Read more
Convert XML (mixed nodes and attributes) to CSV file
I see a post Convert xml (mixed nodes and attributes) to csv file using c#, the poster has an XML which has mix of nodes and nodes with attributes: <?xml version="1.0" encoding="utf-8"?> <Root> <StudentRequestList count="3"> <StudentRequest> ... Read more
Convert XML to CSV with node path as header
I see a post Convert XML to CSV (with node path as header) using XSLT, the poster have this XML data: <tXML> <Header> <Source>XPTO</Source> <User_ID>127</User_ID> <Message_Type>Ship</Message_Type> ... Read more