Quotation Marks in Consolidated Reports

[John Morris]

Hi Doug,
  I've discovered that the bug I just reported is more general that I originally realized. It appears that descriptions, memos and notes are all converted to Word Case. Every "word" in any of these fields gets an initial capital letter and all the remaining letters are converted to lowercase, regardless of how the appear in the original transactions. This means that "CapitalOne" is converted to "Capitalone", "IRS" is converted to "Irs", "AT&T" is converted to "At&T" and "Rewards for the last few months" is converted to "Rewards For The Last Few Months". Apparently, double and single quotation marks (along with at least some other nonletter characters) constitute a word boundary even if they are not associated with white space.

  As I said before, this is a minor bug compared to the convenience of the report, but it would be nice if the descriptions, memos and notes were left unchanged. In fact, the consolidation would make it easy to catch miscapitalized memos if the comparison were strictly case sensitive.

Best,
John

> On Mar 12, 2017, at 12:13 PM, John Morris <johnjeff at editide.us> wrote:
> 
> Hi Doug,
>  Thank you for distributing your improved transaction report. I'm finding it very useful.
> 
>  That said, I did find a strange, but minor, bug in the consolidation code. Any letter that immediately follows a single quotation mark (') is converted to uppercase when the Consolidate Transactions checkbox is set. So, "Annie's Hot Dogs" comes out "Annie'S Hot Dogs" and "Brandon's Diner" comes out "Brandon'S Diner", but "Ca' di Francesco" comes out "Ca' di Francesco". Unchecking the Consolidate Transactions box restores the proper lowercase letters. The same issue appears to apply to letter immediately following a double quotation mark ("). I don't use them in transaction descriptions, so I have not tested this extensively.
> 
> Best,
> John