Test for Beginning of Field?
I'm writing a script to parse an email address out of the 'notes' field of a number of records - finding the percy (@) then stepping back to find a space (or a colon, or a semi-colon, or a comma, or a hyphen (always assuming that addresses follow common practice without such characters*)) then stepping forward to find another space (or ... ) 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.
any help appreciated as ever
[*I guess you could test for every possibility with a very long winded conditional as all characters are theoretically allowed in addresses :( ]