6306
Clipboard Help+Spell / Re: Clipboard Help+Spell - Top Priority Requests for 2011
« on: February 24, 2011, 03:04 AM »
@mouser:
Results:
Is there somewhere you can point me to to bone up on the subject of SQL commands and syntax for CHS?
On a side issue: What is the best way to sort/reorder the virtual folders? I can't seem to get them to behave nicely at all by moving them around.
Sorry if some of this is irrelevant to this discussion thread.
_____________________________________________________________
@rjbull:
Thankyou.
The second item (i.e., retaining the reference of the source URL) would be very useful. That's the sort of thing that I notice OneNote does, but it only does it for copy/paste of text and/images from a web page. If you copy the same section of that web page as a OneNote image clip (using the clipping tool crosshairs), then it loses the source URL.
"See this thread and the sample URL virtual folder in CHS: http://www.donationcoder....um/index.php?topic=4135.0"Many thanks! I took a look at that and then played about with the virtual folders using that SQL.
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: (?)
Is there somewhere you can point me to to bone up on the subject of SQL commands and syntax for CHS?
On a side issue: What is the best way to sort/reorder the virtual folders? I can't seem to get them to behave nicely at all by moving them around.
Sorry if some of this is irrelevant to this discussion thread.
_____________________________________________________________
@rjbull:
Thankyou.
* Categorise/Organise your clips. Create rules/filters for incoming clips.It looks like the first item is therefore already in CHS - and is exactly what I had been looking for but didn't know how to do until mouser pointed it out.
* Quickly access the source web page of internet clips.
The second item (i.e., retaining the reference of the source URL) would be very useful. That's the sort of thing that I notice OneNote does, but it only does it for copy/paste of text and/images from a web page. If you copy the same section of that web page as a OneNote image clip (using the clipping tool crosshairs), then it loses the source URL.