Search Phone Number Field From Parameter 2

[WestView]

Hello All,

I have a report that returns records based on a parameter field that searches a phone number field. Users want to enter just the number into the parameter field i.e. "1234567890" for a field string (inconsistantly) formatted like "(123) 456-7890" or "123-456-7890".

Is this possible?

Thanks!

 

[Madawc]

Do a stripped-down version. Something like
Replace (Replace (Replace (Replace({your.phone}, ")", ""), "(", ""), " ", ""), "-", ""), getting rid of unwanted characters.

Madawc Williams (East Anglia, UK)

 

[WestView]

Madawc,

That worked beautifully!

Thanks!!!!

Tom

 

[Madawc]

I've just remembered - there is a much simpler method. Val({your.phone}) is a dedicated function which will get rid of any non-numerics.

Madawc Williams (East Anglia, UK)

 

[WestView]

Madawc,

Thanks. I tried that, but it stops reading the string after the first non-numeric character. For example, if a phone number in the field is "(123) 456-7890" then it will not return the record.

Your first post worked just fine!

Thanks again,

Tom