Using a separate text field for the email address during data entry might eliminate the need for parsing out the email address in the first place.
i have the same monotonous task too. I would do first what Phil suggested and insert the "found email" from Notes and then perhaps visualy compare and correct.
To stop the infinite loop, use Length function to see the Note field size then decrement till loop ≤ 0 from at start of LENGTH.
You will be , depending on your USER's typing, be 95% sucessful.
"but how do you test for beginning of field? If the email address is the very first string of text in the field, script just loops for ever."
I would add a space to the given field before search for @, something like:
adj = " " & notes ;
thanks Phil and all - separate field absolutely (now three email fields, work, home, other, with selection check box for preferred) - but we're talking an old db that I'm refreshing, so data is in places that it shouldn't be...
thanks Ray - but I think I figured it - test for Position = 1 on each step backwards from the percy, now need to test it to be sure