Hello, I have a phone book app that I made. ...

(CCMET Metrotesting) #1

Hello,

I have a phone book app that I made. My issue is that searching is fine for everything except for phone numbers. Example in the app the phone number is (123)456-7890. If I type in the search box 1234567890 then the app will not find it. I have to literally type in (123)456-7 for the entry to show up.

Is there any way around this?

Thanks!

(Aleksi Alkio) #2

You can create an additional column where you convert all possible scenarious that you could think of, for example… CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Phone],"(",""),")",""),"-",""))

(CCMET Metrotesting) #3

@Aleksi_Alkio Thank you. I was confused at first because of the nesting of substitutes i’s like the formula version of the movie inception! but I got it in the end. The only thing I am still wondering about is the Concatenate part of it because I was assuming that the substitute would already result in a concatenated text.

(Aleksi Alkio) #4

I just added it if you would like to add other possible formats as well. It will work without it tough.

(CCMET Metrotesting) #5

@Aleksi_Alkio which i did! thank you for that.

I concat with another field [Cell]+[DirectLine] So the app can search either way

(Aleksi Alkio) #6

Good :slight_smile: