Sonny Software

Sorry if this is a silly question,

Is there a way to sort entries by the number of paper clips shown in, what I believe is, the "Author" field? This sort would hopefully simply separate those references with one paper clip shown versus those references with two paper clips shown.

I need to go through and delete attachments manually because my database is a mess. I have no idea how to make this more automated (I've already used the remove duplicate function. I used strict criteria first, and then moved to less and less). In any case, there are still attachments that I need to delete.

Thanks for the help,

Tim

You can create a smart SQL group (or just do an SQL search) for this

varCharField REGEX '[\n\r]'

That should find references with more than one attachment.

Jon
Sonny Software

Thank you! Still trying to figure out how to do SQL searches using documentation online.

Use the User Guide (Help menu). There's lots of info about SQL searches in the PDF that you have on the HD, with many examples.

Jon
Sonny Software