Code:
id = Mid(mainrow, InStr(mainrow, "_id") + 6, InStr(mainrow, Chr(34) & "," & Chr(34) & "_rev") - (InStr(mainrow, "_id") + 6))
test = Mid(mainrow, InStr(mainrow, "titel") + 8, InStr(mainrow, Chr(34) & "," & Chr(34) & "categorie") - (InStr(mainrow, "titel") + 8))
short intro: I have a json and am pulling data from it. I had some On Error code before on almost each line though my DB kept corrupting so I went in
for this specific file the error occurs after 280+ lines. Every line is handled by these 2 lines (and several others). The first does not error, the second does BUT the test variable DOES hold the information I want. checking the InStr's they return 0.
the issue occurs on different files too, all the same format, other records
I fear resuming or acting on error is what eventually corrupts the DB, though truth be told I just started Access and don't know much about it
If anybody can indicate a possible flaw in the lines, or advise how to proceed on this that would be quiete some help