Search through individual data strings

[bcmiller]

Hi All,

I am writing a macro that searches for a variable seven digit numbe
sequence. The number sequence is in a text field and is not in
standard position (ie: in record one it is at position 20, record 2
position 9, record 3 - no entry, record 4 - position 12 and positio
123, etc). The field contains other text and numbers that are no
required and may contain more than one valid number sequence. Doe
anyone have an algorithm that could help me with this process.

Regards

B

 

[Frank Kabel]

Hi
you may use
InStr
for this in your comparison