> What's your criterion for separating fields into lines? Your example is
insufficiently informative.
Gil,
This is my interpretation of the requirement. Treat the entire data that OP
showed as a single line of data and OP wants to split the records beginning
with open curly bracket { and end with a closing curly bracket }
So the individual records would be like after the running that I showed
earlier.
{"date":"20200616-0400","MMSU":11206,"IH":35,"X":302}
{"date":"20200616-0500","MMSU":11235,"IH":29,"X":303}
{"date":"20200616-0600","MMSU":11269,"IH":34,"X":304}
{"date":"20200616-0700","MMSU":11309,"IH":40,"X":305}
{"date":"20200616-0800","MMSU":11352,"IH":43,"X":306}
{"date":"20200616-0900","MMSU":11403,"IH":51,"X":307}
{"date":"20200616-1000","MMSU":11459,"IH":56,"X":308}
{"date":"20200616-1100","MMSU":11516,"IH":57,"X":309}
{"date":"20200616-1200","MMSU":11585,"IH":69,"X":310}
{"date":"20200616-1300","MMSU":11639,"IH":54,"X":311}
{"date":"20200616-1400","MMSU":11689,"IH":50,"X":312}
{"date":"20200616-1500","MMSU":11742,"IH":53,"X":313}
{"date":"20200616-1600","MMSU":11805,"IH":63,"X":314}
Thanks,
Kolusu
DFSORT Development
IBM Corporation
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
