Circumflex accent in search

Viewing 2 reply threads
  • Author
    Posts
  • March 18, 2017 at 2:42 AM #21459

    Chris Ward
    Participant

    I have discovered by chance that placing a circumflex accent (^) before a word in the search field limits the search to items that commence with that word.
    Q1. Where is this feature documented, and what similar features are available, if any?
    Q2. Can I stop this feature, given that I use this symbol in my database for another purpose, which this conflicts with?

    March 18, 2017 at 11:11 AM #21460

    Brendan
    Keymaster

    Actually all punctuation is removed from the search index at the time of saving. So having punctuation in your search term should have no effect on the search. Tap Forms always does a prefixed search for words that begin with the search term specified.

    March 18, 2017 at 11:28 AM #21461

    Chris Ward
    Participant

    I get different results if I use these three terms in the search box top right

        Name
        ^Name
        ^ Name

    “Name” and “^ Name” are the same, so yes, I can see the ^ is ignored.
    But if I put “^Name”, I get no results at all, so in this case the ^ is not ignored, the whole term is.
    Unfortunately, this is exactly what I use to prefix certain words, to distinguish them from other (irrelevant) use of the word. I suppose I could use “xxName”, but it somewhat compromises readability.

Viewing 2 reply threads

You must be logged in to reply to this topic.