SQL/Regex Search for file extension in attachments
Posted: Mon Mar 15, 2021 3:40 pm
Hello,
I'm trying to do a smart group that identifies all the refs with attachment files that are .epub.
I tried 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.
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'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.
