Telephone Numbers

[simoncpage]

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

[Lee Smith]

New calculation field with this calculation Result is Numbers

TextToNum(YourTelephoneNumberFieldHere)

Lee

[ESpringer]

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

[Lee Smith]

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

[simoncpage]

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

[BobWeaver]

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.