https://communities.sas.com/t5/SAS-Programming/CSV-file-with-JSON-field-where-the-JSON-field-is-bigger-than-32K/m-p/573115#M161758 <P>I have a CSV file which has a few fields like ID (PK), and other IDs (FKs), then a massive JSON field, then a few more fields after that.</P> <P>&nbsp;</P> <P>My concern is how can I read that massive JSON field if it's over the <SPAN>32,767 bytes limit?&nbsp; The next step after reading it in is parsing the JSON field.</SPAN></P> <P>&nbsp;</P> <P><SPAN>I am able to parse out the JSON when I don't read in the records over the limit.&nbsp; It creates 19 tables!&nbsp;&nbsp;</SPAN></P> Fri, 12 Jul 2019 14:45:22 GMT Areksoo 2019-07-12T14:45:22Z https://communities.sas.com/t5/SAS-Programming/CSV-file-with-JSON-field-where-the-JSON-field-is-bigger-than-32K/m-p/573115#M161758 <P>I have a CSV file which has a few fields like ID (PK), and other IDs (FKs), then a massive JSON field, then a few more fields after that.</P> <P>&nbsp;</P> <P>My concern is how can I read that massive JSON field if it's over the <SPAN>32,767 bytes limit?&nbsp; The next step after reading it in is parsing the JSON field.</SPAN></P> <P>&nbsp;</P> <P><SPAN>I am able to parse out the JSON when I don't read in the records over the limit.&nbsp; It creates 19 tables!&nbsp;&nbsp;</SPAN></P> Fri, 12 Jul 2019 14:45:22 GMT https://communities.sas.com/t5/SAS-Programming/CSV-file-with-JSON-field-where-the-JSON-field-is-bigger-than-32K/m-p/573115#M161758 Areksoo 2019-07-12T14:45:22Z https://communities.sas.com/t5/SAS-Programming/CSV-file-with-JSON-field-where-the-JSON-field-is-bigger-than-32K/m-p/573135#M161763 Yeah, it's likely in a relational type format that you'll have to link but unfortunately JSON doesn't have defined structure. It's curse and benefit at the same time. Fri, 12 Jul 2019 15:15:51 GMT https://communities.sas.com/t5/SAS-Programming/CSV-file-with-JSON-field-where-the-JSON-field-is-bigger-than-32K/m-p/573135#M161763 Reeza 2019-07-12T15:15:51Z