Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Finding e-mail addresses

Finding e-mail addresses

Finding e-mail addresses

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

RE: Finding e-mail addresses

when I do a find in a email field and type "@" it pulls all the records with a email address.

RE: Finding e-mail addresses

I have a field called "email" and there are many records where this field is populated with a valid email address. I manually copy an address from any record, hit "find",  paste the address into the "find" email field and then enter. "No records match this set of find requests' is always the answer.

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

The Problem is that the @ symbol means one character in a find in FM. If you enter find mode and click on the symbols tab in the left you will notice the types of symbols and what there meaning is. You need to use quotes before and after the @ symbol to make it a literal search on the @ character. Then it should pull all your records with @ in the email field. Is this what you are wanting to do, or am I misunderstanding?

RE: Finding e-mail addresses

Tcoyle, you understood perfectly!

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?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close