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

The dot is delimiter.

@ is wild character.

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.

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

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

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]

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.

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