There are "wildcards" that help with FileMaker finds. Keep in mind that the default is "begins-with", so to get something in the "middle", you need to use wildcards.
You probably want
to get 02081234567
also research Constrain and Extend
(follow all the links on the above page)
Thanks Beverly, and for the links, but two things..
Firstly I thought I'd just try the wildcard approach, and did a find for "*208". I got the error message...
Secondly if searching is, by default, set to 'begins with' then I don't understand the previous behaviour, unless something else has changed now, because before having the filter() applied I COULD search from within field (i.e. looking for 123 would bring a result). The only thing I couldn't do was search over a 'space', which is why I thought filtering the out would be the solution.
What error message? can you post a screen shot? (Or are you saying nothing was found?)
What type of field do you have (number? text?) and what type of storage is on the fields.
You are just auto-entering to change the contents, correct? it's not a calculation field, is it?
The message is that no records are being found that match.
I have the fields set as text, indexed, auto-enter calculation replacing existing value, with no storage set (that I know of).
Yes, the calculation is there simply to ensure that no matter where (if) someone enters a space, when entering the numbers, they will appear without as I 'thought' that would make searching easier.
Is there a way to attach a file? I've made a very simple one up that shows how I've got it set and what I'm seeing
If you click in the phone field and select "From Index..." from the "Insert" Menu, do you see the number you're searching for in the "View Index" dialog that opens ?
short answer: use *208*
long answer: when you are using wildcards, you are entering a new path.
* means 0 or more characters, so using *208 actually translates into "find everything that ends with 208".
*208* means find 208 anywhere in the content.