In one field in a CSV file is a JSON object that I wish to parse into Excel. The difficulty is that the JSON string sometimes might be longer than the 32K character limit for an Excel cell so if I import the CSV into an Excel sheet it will be incomplete.
Is there any way to read the CSV directly into VBA, parse it, extract the JSON and parse that? If not, am I better to read the CSV file, extract the JSON object, save that to disc then re-import that directly into Excel?
Worst case is using some sort of Powershell script but I'm trying to avoid any external processing.
Thanks in advance!
Bookmarks