11 Replies Latest reply on Dec 3, 2013 3:29 PM by philmodjunk

    Find in a text field:  Why finds Root.pdf but not Root2.pdf?

    wendy

      Title

      Find in a text field:  Why finds Root.pdf but not Root2.pdf?

      Post

           I just don't get this logic, and I don't understand how to explain to others how to find what they need in our database!

           We have a file with thousands of records.  We're searching a text field called "Image Filename".  We have these three records:

           ConstructionSite.pdf
           TreeRoot.pdf
           TreeRoot2.pdf

           Someone was trying to find all image names with an extension of .pdf.  We've always thought using asterisks on both sides of the find request would get you every match possible, no matter what surrounded the string to be found. So I told them to search for

           *.pdf*

               ...Only the first two came up!   Searching for

           .pdf         (dot pdf, no asterisks)

               ...only bought up TreeRoot2.pdf.

           Searching for

           pdf          (plain old stand-alone   pdf)

               ...also brought up only TreeRoot2.pdf

           Could someone explain the logic?  Seems like I have to let go of my idea of "when in doubt, surround the find string with asterisks"...

           How to find all images with an extension of .pdf??

           Thank you!