Search for attachment file name

A place for users to ask each other questions, make suggestions, and discuss Bookends.
Post Reply
martinjp
Posts: 68
Joined: Tue Jan 28, 2014 4:25 pm

Search for attachment file name

Post by martinjp » Sun Feb 02, 2020 3:24 pm

Sorry to be dense, but how do I search for an attachment name? I'm looking for, for example, Anonymous 289.pdf. I've tried an SQL search on the field 'attachments,' but that doesn't work.

Martin

Jon
Site Admin
Posts: 8429
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: Search for attachment file name

Post by Jon » Sun Feb 02, 2020 3:45 pm

If you mean search the HD for the file, there are a number of ways, but perhaps the simplest is to right-click on the paper clip or the references and choose "Show Attachment in Finder".

If you mean something else reply to this post.

Jon
Sonny Software

martinjp
Posts: 68
Joined: Tue Jan 28, 2014 4:25 pm

Re: Search for attachment file name

Post by martinjp » Sun Feb 02, 2020 6:36 pm

Hi, Jon. No, I have the attachment in the Finder, and I'm trying to track down the reference that it's attached to. It's probably an empty reference, since the attachment has not been renamed. I figure there's an obvious way that I simply haven't stumbled across. (I learn most things by stumbling across them...)

Martin

Jon
Site Admin
Posts: 8429
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: Search for attachment file name

Post by Jon » Sun Feb 02, 2020 6:44 pm

Did you try the attachment (spotlight) live search? Or the equivalent in the Find window?

Also, the SQL search will work, but I think you need to escape the period (try REGEX '(?i)name\.pdf')

Jon
Sonny Software

martinjp
Posts: 68
Joined: Tue Jan 28, 2014 4:25 pm

Re: Search for attachment file name

Post by martinjp » Sun Feb 02, 2020 9:22 pm

Do you mean this? It throws an error...

attachments = REGEX '(?i)Anonymous 289.\.pdf'

If I use the Spotlight option in the Find box, typing 'Anonymous' brings up all the pdf's *containing* the word, as well as in the titles. If I try "Anonymous 289" (with single or double quotes) I get zero hits.

Martin

Jon
Site Admin
Posts: 8429
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: Search for attachment file name

Post by Jon » Mon Feb 03, 2020 8:25 am

attachments REGEX '(?i)Anonymous 289\.pdf'

Jon
Sonny Software

martinjp
Posts: 68
Joined: Tue Jan 28, 2014 4:25 pm

Re: Search for attachment file name

Post by martinjp » Mon Feb 03, 2020 2:29 pm

Got it! :)

Thanks

Martin

Post Reply