Nir Sofer's freeware tool SysExporter can do some of what you want:

-rjbull (May 06, 2011, 02:03 PM)

Thanks, I'll have a look at it.

Kevin

[box-off]
Just thinking out of the box a little, so perhaps these are a bit of a stretch to request these as features of CHS, but I think these features would be a great addition for debugging/programming.

(Note: When I say Copy, I mean to create as a new CHS clip, and could also consider to copy the text/image to the clipboard.)

Copy URL's of all open Windows and Tabs of the Default-Browser.

Copy URL's of all open Windows and Tabs of the Specified-Browser.

Copy Full-Path of all open Windows of Windows-Explorer.

Copy the Window-Title of all open Visible and non-Visible Windows/Applications.

Copy the Window-Handle of all open Visible and non-Visible Windows/Applications.

Copy the App-Command-Line of all open Visible and non-Visible Windows/Applications.

Copy the App-exe-path-and-filename of all open Visible and non-Visible Windows/Applications.

[/box-off]

If anyone knows of another tool that can already do some of this, please reply.

Kevin

Results:

• All clips with URLs were filtered OK using the rule: (Lower(ClipText) LIKE '%http:%') OR (Lower(ClipText) LIKE '%www.%') OR (Lower(ClipText) LIKE '%ftp:%')
• All clips with "the" in the text filtered OK using the rule: (Lower(ClipText) LIKE '%the%')
• Text filtering failed using a rule with an upper case character as the first character in the filter string- e.g., (Lower(ClipText) LIKE '%The%') - so it looks as though the syntax is upper-case-averse.   :tellme:  (?)

-IainB (February 24, 2011, 03:04 AM)

Iain,

This is not actually a "Failure" of the software but actually the behavior of the "Filter-Code" that was specified.

The SQL "Filter-Code" you have specified: (Lower(ClipText) LIKE '%The%') means to:
1) look at a copy of the text of each clip
2) convert the copy of the clip text to lower case with "Lower()"
3) take action based on match (or not) to your text "The" which contains an uppercase letter, and can never match the clip which is being viewed as all lowercase.

The original SQL "Filter-Code" by mouser that you copied from was constructed to be case insensitive. If you want to do a case sensitive compare/match, just take out the "Lower" term like:
((ClipText) LIKE '%The%') ... or perhaps: (ClipText LIKE '%The%')

Kevin