Hey

Anyone help me with this I want to be able to add a search that will find numbers with and without spaces for example

Actual entry: 1234 2300

Search either:

1234 2300

or

12342300

so with either it will come up

One way I thought was via script and to create another field (calculation) "No space telephone" but is there another way?

Simon

New calculation field with this calculation Result is Numbers

TextToNum(YourTelephoneNumberFieldHere)

Lee

If the field has the "number" format it will already ignore spaces, dashes, letters, etc. when you do a find or a sort.

Not for a find in a number field that has spaces in it. Besides, Simon described the field as having spaces, hypens, etc., (like a phone number) in the field. Hense the Subject Telephone Numbers probably.

Lee

The phone numbers fields are stored as "text" fields. However when I do text to number calc field the numbers arent quite right in that a number begining 0207 comes our as 207.

Plus on search for this text_to_num field i am not able to search for numbers fully for instance the tex_to_num field shows this:

02174860655

suppose I wish to search for the "7486" or "0655" ?? and how do I search for "7486 0655" with the space??

Thanks

I think you may need to use the substitute function to remove all the usual phone number separators

Substitute(Substitute(Substitute(Substitute(PhoneNo, "(", ""), ")", ""), "-", ""), " ", "")

And keep all the fields as text so you don't lose leading zeros.