Solved

Parse portions of email address in FileMaker Pro

Posted on 2008-06-18
3
592 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
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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 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