'How to write Json null value as an empty line in new file (converting json based log into column format, i.e., one file per column)
example of log file:
{"timestamp": "2022-01-14T00:12:21.000", "Field1": 10, "Field_Doc": {"f1": 0}}
{"timestamp": "2022-01-18T00:15:51.000", "Field_Doc": {"f1": 0, "f2": 1.7, "f3": 2}}
It will generate 5 files:
1.timestamp.column
2.Field1.column
3.Field_Doc.f1.column
4.Field_Doc.f2.column
5.Field_Doc.f3.column
Example content of timestamp.column:
2022-01-14T00:12:21.000
2022-01-18T00:15:51.000
I'm facing a problem while the values of keys are null, undefined as when the value us is null for example:
{"timestamp": "2022-01-14T00:12:21.000", "Field1": null, "Field_Doc": {"f1": undefined}}
can someone help me out here?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
