Recent content by versn

on a delimited text file, searching a row for a specific string, having the delimitations in an array, will mainrow() suffice as a location indication in which start and end reference point given, if both points are in a different 'field' or 'array element'. at this point it will just shorten...

so im starting from JHB's version though I was wondering the next, I'll be splitting on comma in this version meaning the position of the references is variable and not defined. So I put the fields in an array Do count and check all fields in input record (beta)...

impressively short. It's not all how the data should come but im prolly diving into it tomorrow to get the hang of this one. Big thanks already; 52 seconds and no corruption, no errors and seemingly no data loss. Thats my current result times 5 ++

im pulling data into a table to get it nice and orderly, the data itself will serve as product information to be used on a site, after recompiling/comparing/binding/parsing/etc. (im up for a long road of frustration as it looks now) Im basically making a row of data and then putting it in the...

I suspect the json itself has severed some corruption I changed some small things according to what the_doc_man said for but 2 data captures, though I ran it on a different file. I was called away from my computer and the db actually ran for at least 15h (while there is NO way it should take...

no ","categorie":"ISDN comes right after the string needed. the string is easily contained and did not invoke issues on a lot of different rows the thing is that the issue occurs for most of the items on the record, the specific indication of error here is just saying this is the first item...

Re: Error5 invalid proc. call or arg. on specific record, "strange" instr behavior? Error 5 invalid procedure call or argument. I checked the line but it's okay. I use the data references I put up to get the data out and they're the exact same on every line. I split the original file on '}'...

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...