SQL/Regex Search for file extension in attachments

[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.

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.

[Jon]

I think you have to escape the period with \

'\.epub'

(untried)

Jon
Sonny Software

[mjvalente]

And... that worked!