Extract content from JSON-structured text
QuickTable can easily extract specified content from JSON-structured text. You can find it by clicking JSON > Extract content in the toolbar.
In this example, you want to extract "user" and "country" from a JSON text, just like the data in the previous image.
After you click the Extract content in the toolbar, you will see the configuration panel as follows:
Then, select the column json_content, and the content of the first row will be parsed and appear below:
You can change the parsed data by modifying the row number:
The parsed data is just to assist your operation, and it will actually be performed on all rows of data. You can add elements to the extracted list by clicking the "+" icon:
QuickTable extracts the content of JSON by parsing the JSON path. In most cases, just click the "+" to automatically generate the path. If you have complex extraction scenarios, you can manually enter extraction paths.
Click "Save", you will get your expected result.
Last updated