AnsweredAssumed Answered

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

Question asked by wendy on Dec 3, 2013
Latest reply on Dec 3, 2013 by philmodjunk

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!

Outcomes