JGF

The only problem is that I am updating on import, so if it does not match, where does the data go? It is the data that does not get updated that I am concerned about.

I am import/updating records on match and I need to capture the records that do not match, so I can manually match/update them. How can I do this?

I am still having this same problem? does anyone have any experience with storing emails under something other than unicode, if so how are you retrieving those records, when I changed mine to english I couldn't find anything by simply putting in the email I was looking for. TIY

I tried indexing in english and that made it worse, so I switched back to unicode. tia Joshua p.s. I know about the "" and also that I can escape @ with a /

I am having trouble when performing finds in our email field. What is happeing is that I usually have an email in lowercase to search with and some of the data has uppercase. This makes it hard to search since email address is the one field I always use to perform a search. Is there any way to make it find both cases with one search? tia Joshua P.s. Filemaker is retarded when it comes to email, they have the @ symbol as a reserved character!?!

That is the indexing, I shall have to play with it a bit

Thanks that may just be what I need! Any ideas why import/export are not web features?

I actually already have a program that does not use it. I have been looking for a while to find a replacement as this one was writin many years ago and was written for dos and is no longer supported. It just seems that in these days of working on the web file make gives a little of a tease at functionality and stops short of full use. the web sharing could be enhanced and so could thinking that many people would use email addy's in their database and not reserving the one character that is in email...oh well, I guess I shall either live with it or move on

well if that is the case, filemaker is a broken limping dog to me

I know, what I am asking is there a way to get around this... as it makes searching for email addresses more complicated than it needs to be.

I need to know if there is a way to find email addresses without having to "" or /@ in the search. We perform most of our searches with email addresses. Sorry if this has been covered, I couldn't find it. J