SQL/Regex Search for file extension in attachments

A place for users to ask each other questions, make suggestions, and discuss Bookends.
Post Reply
mjvalente
Posts: 35
Joined: Tue Dec 15, 2015 8:13 am

SQL/Regex Search for file extension in attachments

Post by mjvalente »

Hello,

I'm trying to do a smart group that identifies all the refs with attachment files that are .epub.

I tried

Code: Select all

attachments REGEX '.epub'
but that does not work and I suck eggs in REGEX. :oops:

Can someone help me?

UPDATE: the REGEX does work, but beside all the epub files it also returns the references that have republic on its title. So, I guess I only need a little nudge on the proper REGEX terminology.
"If we knew what it was we were doing, it would not be called research, would it?"
Jon
Site Admin
Posts: 10048
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: SQL/Regex Search for file extension in attachments

Post by Jon »

I think you have to escape the period with \

'\.epub'

(untried)

Jon
Sonny Software
mjvalente
Posts: 35
Joined: Tue Dec 15, 2015 8:13 am

Re: SQL/Regex Search for file extension in attachments

Post by mjvalente »

And... that worked! :)
"If we knew what it was we were doing, it would not be called research, would it?"
Post Reply