How to clean up the converted Json string from non Json ansi characters in Ms Access VBA
Is it possible to Trim the first 4 characters & the second last from the Json string below, the idea here is to remain with pure json, so that if I fail to iterate it , then I can have it printed and posted to the table manually.(Characters not required are ] j and 4c)
Below is the Ms Access VBA code that takes it to text file , but not fully cleaned up.
Text file Export VBA
n = FreeFile() Open "C:\Users\chris.hankwembo\Desktop\Leader\test.txt" For Output As #n Print #n, strData Close #n