How to extract specific text from a BLOB file

[Doogster]

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:

ENTRY_LINES=SECTION1=N026F005_SECTION=1N026F015_WEEK_NO
=N026F020_TIME_TYPE=WORKN026F022_ALLOW_TYPE=N02
6F025_DATE=20051229N026F030_TIME_FROM=0000000005300000
N026F035_BREAK_FROM=0000000010300000N026F040_BREAK_T
O=0000000011000000N026F045_BREAK_HOURS=N026F050_TIM
E_TO=0000000016000000

In the above example the text "N026F025_DATE=" occurs many times. I need to extract each instance of that text and the characters after the equals sign (which in most cases are different).

Any hints would be greatly appreciated.

Regards. Doogster

 

[johnwm]

Welcome to Tek-Tips. Read faq222-2244 to get the best from these forums. In this case you need to ask VBA questions in the VBA forum, that's forum707

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller