RE: Stop! Do Not Merge Cells in Excel - Heres why with fixes
You are viewing a single comment's thread:
@paulag sorry for the off topic comment.
Just a quick question.... can you find a quick way for parsing json like this
{"contractName":"tokens","contractAction":"stake","contractPayload":{"symbol":"SCT","quantity":"0.369","to":"discernente"}},{"contractName":"tokens","contractAction":"stake","contractPayload":{"symbol":"ASS","quantity":"0.00000861","to":"discernente"}},{"contractName":"tokens","contractAction":"stake","contractPayload":{"symbol":"ACTNEARN","quantity":"0.08","to":"discernente"}},{"contractName":"tokens","contractAction":"stake","contractPayload":{"symbol":"SPT","quantity":"117.095744","to":"discernente"}},{"contractName":"tokens","contractAction":"stake","contractPayload":{"symbol":"SPACO","quantity":"0.31620755","to":"discernente"}}
It has a multiple jsons in it ... the way I do it is first split it by delimiter and then parse it individually. If there is a better way to do it at once, I will be very happy :)
hi, yes it can be split in Excel using power query. however you might have to split it into a number of queries and then merge the queries. I would have to see how the raw data pulls into excel first. Are you on discord?
Yes ... discord dalz#3699
I cant seem to connect to you, may you can try connect to me paulag#0515
Thanks for the reply.
Here is what I got :)
Im glad we hooked up and got you sorted :-)