Im working with a project which deal with very long and complicated json data structure, i have 3 types of json data and i want a specific string value which is contextJSON but the problem is that, the string contextJSON is not located on a particular location,
If anyone know any logic to find contextJSON from my long json, please suggest me
These are my JSON data i m working with
output 1.txt (41.4 KB)
output 2.txt (96.4 KB)
output 3.txt (125.0 KB)
You need a good json formater
so path shoudl be
require, 2, 4, 1, contextJSON
I only checked your output 3.txt
1 Like
Can i do this with the help of inbuilt dictionary blocks
ABG
October 27, 2024, 6:48pm
7
You could also cheat and take advantage of the fact that the text appears only once, and is always followed by ,\r\n"isGuideEmbed":
That's just two text splits, as in the Taifun parse procedure.
Correction - that only works on JSON that has been Tidied.
ABG
October 27, 2024, 11:26pm
8
Because of the varying tree structure in these samples, a more general purpose approach was needed.
Here is my general purpose table extractor, able to extract tables from mixed dictionaries and tables, given a list of headers.
I preloaded it with your 3 sample JSON files.
parseJSON.aia (59.3 KB)
3 Likes
Kevinkun:
so path shoudl be require, 2, 4, 1, contextJSON
this block will be enough:
2 Likes
system
Closed
November 4, 2024, 5:18am
11
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.