DonationCoder.com Software > Clipboard Help+Spell
Clipboard Help+Spell - Top Priority Requests for 2011
IainB:
@mouser: Oh! Thankyou! I had missed that new feature. Sorry for not paying attention! :(
mouser:
It's brand new and i wasn't sure it if worked well enough to enable it by default so it's not surprising that it's not a very well known feature.
sosimple:
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)
--- End quote ---
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
sosimple:
Add a feature to "explode" a clip based on various delimiters (opposite of merge), so for example:
1) Clip is:
"Apples
Bananas
Oranges
Pears"
...("Apples\nBananas\nOranges\nPears")
or 2) Clip is: "Apples, Bananas, Oranges, Pears"
Then to explode a clip would make 4 new individual clips.
Delimiters could be "automatically guessed", or could be selected from a list of common delimiters, or specified during use.
Kevin
mouser:
not a bad idea. maybe the easiest universal solution would be a function that would let you put in a regular expression, and would extract all matches as new clips.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version