Finding e-mail addresses
Finding e-mail addresses
(OP)
I am writing a program to find changes between old and new "backups" of a membership database. In particular I want to extract e-mail addresses that have been removed and those that have been added.
Problem is that the find function does not seem to work properly on e-mail addresses, and the "@" character is the villain of the piece. Just try a manual find on a field you know exists but contains "@" - it cannot be found!
Am I being totally stupid, or is it a problem with a simple solution?
Thanks for advice
Problem is that the find function does not seem to work properly on e-mail addresses, and the "@" character is the villain of the piece. Just try a manual find on a field you know exists but contains "@" - it cannot be found!
Am I being totally stupid, or is it a problem with a simple solution?
Thanks for advice
RE: Finding e-mail addresses
RE: Finding e-mail addresses
If I then keep repeating the find after deleting the last character, then next-last etc. the find starts to work when I have deleted the @
But I spent a long time examining my script for errors before I worked out this simple test!
PS I am using FileMaker Pro 8 Advanced
RE: Finding e-mail addresses
RE: Finding e-mail addresses
I was performing a loop to copy each email address from "old records" to a variable, then pasting the variable into the search field of "new records" and performing the search to see if the email address was still valid. Of course, I now see why that failed.
Solution was to amend the Set Variable line to incorporate a Substitute function when copying the old email address, thereby changing the single-character @ to the three-characters "@" during the copying process.
Many thanks!
PS I wanted to copy a few of the actual script lines into the above message for the possible benefit of others who may not have fully understood - but I have never yet managed to copy scripts FROM FileMaker TO a text edit program. Any suggestions about that one?