This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
You can create an additional column where you convert all possible scenarious that you could think of, for exampleโฆ CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Phone],"(",""),")",""),"-",""))
@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.
LinkedIn
Twitter
