Two interesting sites to ease transforming JSON fragments in log-messages to a table system, for instance Excel.
- Paste the bits in [WayBack] Best JSON Pretty Print Online then fix any syntax errors.
- Copy from there to [WayBack] json2table.com and press the triangle button (run)
- Copy either the tabular or tree result to your favourite program.
- Format any numbers for readability. I really like the
Custom
format##0.00E+00
that just shows the exponents in multiples of 3 (so kilo, mega, giga, etc)[WayBack] formatting – How can I format bytes a cell in Excel as KB, MB, GB etc? – Stack Overflow
This way I copied the example code into adjecent Excel areas, so I could compare the values and calculate memory increase of a Delphi application.
—jeroen