Solved

Parse portions of email address in FileMaker Pro

Posted on 2008-06-18
3
595 Views
Last Modified: 2012-06-21
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
Comment
Question by:movefiles
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 19

Accepted Solution

by:
billmercer earned 250 total points
ID: 21817048
" 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
 

Author Closing Comment

by:movefiles
ID: 31468407
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
 
LVL 1

Expert Comment

by:npthinktank
ID: 23900094
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Filemaker List Function Numbering returned items 2 594
Filemaker import xml 3 202
How to clone database on FileMaker server 11 2 219
Does Surface Pro 2 have a max broadband speed 18 190
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question