Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 644
  • Last Modified:

Parse portions of email address in FileMaker Pro

I want  to parse right or left portion of email address in FileMaker Pro v9 but am stumped by the "@" symbol. I know it's a wildcard lookup character; I also know that by enclosing it in quotes I can perform a literal lookup, but in a formula, where it's potentially necessary to use a wildcard symbol AND the literal symbol, how do I affect this? Stumped, need help, can't find anything online about this and FileMaker Pro v9.
0
movefiles
Asked:
movefiles
1 Solution
 
billmercerCommented:
" but in a formula, where it's potentially necessary to use a wildcard symbol AND the literal symbol"

Can you be more specific about the problem you're encountering?

The @ symbol as a wildcard applies when doing a database find, but you can't perform a find from within a formula, so I'm not sure how  these two uses of the @ symbol are conflicting with each other.

To parse the name and domain portions of an email address, this works:

LeftPart = Left(email;Position ( email; "@"; 1 ; 1 ) - 1 )

RightPart = Right(email; Length(email) - Position ( email; "@"; 1 ; 1 )   )

When doing a find for an email address, if you want the find to consider the @ symbol as literal text, just put a \  (backslash) in front of the @ and FileMaker will consider it literal text rather than a wildcard. This works for other symbols used by Filemaker as wildcards also.

Is there something more to the problem than this?


0
 
movefilesAuthor Commented:
Thanks! It seemed as if we'd tried that but I was one who made the mistake. You made it very clear, a great solution to a problem I'd wrestled with. Thank you very much.
0
 
npthinktankCommented:
Your formula is a thing of beauty.

It worked perfectly, and saved at least an hour of "hacking away" at a much less elegant formula myself, or alternatively even morel time in manually trimming the emails with less accuracy.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now