Parse portions of email address in FileMaker Pro
Posted on 2008-06-18
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.