Extracting String From Memo Field

Brian, your the best thanks Sir :)
 
Brian, I tested it's working perfect, except there is one condition, it's also pulling any words that are 10 characters long, in your code i know you are specifying only 10 characters that include numbers right? if this is the case it shouldnt' pull 10 characters that dont include numbers! Am I correct? Thank you so much again.
 
:o
As you can see by the number of Gotos it was coded in a hurry, this also caused poor testdata design , add the line in red and it should be ok. Will not be back till weekend so hope it works ok.

Brian



Code:
y = y + 1
    Loop
   [COLOR="Red"] GoTo cont                           ' no numeric[/COLOR]
addtomysrch
:
 
Please refrain from deleting threads once they have been answered. It is unfair to those who have provided answers to your question.
 
Thanks for restoring this thread John, I did pm mr moe when I couldn't find it to check if all was ok but he didn't respond, makes it unlikely that I will bother with him again.

Brian
 
Thanks for restoring this thread John, I did pm mr moe when I couldn't find it to check if all was ok but he didn't respond, makes it unlikely that I will bother with him again.

Brian
An understandable reaction give the effort you have invested in this thread.
 
The owner of the thread can delete reponses from others?
The entire thread was deleted, which I find disrespectful of the effort put in by those who went to the trouble of responding to the OP. Had there been an inappropriate or off topic response, yes deletion (of a single post) might have been valid.
 

Users who are viewing this thread

Back
Top Bottom