Searching email addresses?

[flexistentialism]

I'm probably being stupid but I seem to be having difficulty searching for records based on email addresses

The database returns no records found error. I have found that if I take out the dots and @ and just leave the text it will find the record!

Any suggestions

Thank you

[Anatoli]

The dot is delimiter.

@ is wild character.

[flexistentialism]

I thought that the @ and dot must be reserved characters, do you know of any way around this, maybe get lasso to filter out the dots and @'s.

If I find a way round I will post back

hmmmmmm.

[Anatoli]

You can try to search in another Calculation Field for e.g. "xxx", where

Substitute( origfield; "@"; "xxx")

The ; is my system delimiter in our country, you may have "," coma

[flexistentialism]

Got it working. Fairly complex due to the exact match field restriction on username and password fields so involves two databases.

[elvis_impersonating_penguin]

i found that if you put quotation marks around the e-mail address when you do the search it will find it...

for example search for:

"[email protected]" instead of [email protected]

[Anatoli]

quote:

---

Originally posted by bman:

i found that if you put quotation marks around the e-mail address when you do the search it will find it...

for example search for:

"[email protected]" instead of [email protected]

---

That is literal search. Now I do not know, if that is still fast in indexed fields, or if it is searching without index just by text string.

[flexistentialism]

I hadn't thought of searching for the email address using a literal search Sometimes it's too easy to over complicate without stepping back and thinking about the problem!

I think even if the literal search isn't as fast as a "normal" search it will be faster than the process I have (over) produced

I can't get around using two databases because of the field restriction but at the moment I'm going through several string_replace steps and then search on a calculated field which from what bman has said is somewhat unnecessary

Cheers guys