Search results for query: *

Hi CMP Thanks for that suggestion. Each BLOB file is around 20,000 characters, so a string is not appropriate. Cheers. Doogster

Hi folks I'm attempting to extract some text from a BLOB file in Excel using VBA using the GetChunk method. According to the Microsoft help file, GetChunk is used as follows: Set variable = recordset ! field.GetChunk (offset, numbytes) I understand all of this except for the "recordset ...

Thanks Bob No, there will not always be the same number of chars after the =, which is what makes this so frustrating. The N026.... does span lines. I was thinking of using the GetChunk method, while using InStr to locate each instance of the data I want to extract. Hopefully I can then copy...

Hi folks I posted this yesterday in the VBA Forum, but overnight it vanished. I got a notification that MiggyD had responded to it, but as the thread was deleted, I couldn't see the response..... Anyway, here's the original thread (let's hope it too doesn't vanish): I have several large BLOB...

Hi folks I have several large BLOB files from a Uniface application which contain text and junk characters. I need to extract certain pieces of text from the BLOB file. Is this possible using VBA using either Excel or Access (versions 2003)? Here is a small portion of one BLOB file...