| Button handy |
|---|
| blank | true |
|---|
| color | #0052CC |
|---|
| name | Send Feedback |
|---|
| link | https://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=JSONifying+a+String+with+Unusual+Dimensions+-+491001957 |
|---|
| width | auto |
|---|
|
We have all had instances when we need to aggregate data together, but because of an extra comma or quote character, there is no way to make the data uniform. Do you need to have data fit and cannot figure out how to make your JSON take shape? If so, read on!
...
We can use this to our advantage by using the replace routinefunction:
| Code Block |
|---|
keyBody = replace(keyBody, "|", ","); |
|
...
We've encountered an issue exporting this macro. Please try exporting this page again later.