Page 1 of 1

Search for attachment file name

Posted: Sun Feb 02, 2020 3:24 pm
by martinjp
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

Re: Search for attachment file name

Posted: Sun Feb 02, 2020 3:45 pm
by Jon
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

Re: Search for attachment file name

Posted: Sun Feb 02, 2020 6:36 pm
by martinjp
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

Re: Search for attachment file name

Posted: Sun Feb 02, 2020 6:44 pm
by Jon
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

Re: Search for attachment file name

Posted: Sun Feb 02, 2020 9:22 pm
by martinjp
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

Re: Search for attachment file name

Posted: Mon Feb 03, 2020 8:25 am
by Jon
attachments REGEX '(?i)Anonymous 289\.pdf'

Jon
Sonny Software

Re: Search for attachment file name

Posted: Mon Feb 03, 2020 2:29 pm
by martinjp
Got it! :)

Thanks

Martin