I was wondering if there was a way to override the case-sensitive sorting. For instance when I view posted transactions and am looking for ACME Co it shows up in a different area of the list than Acme Co.
Thank you.
Case-sensitive sorting
Moderators: Moderators, Tech Support
Re: Case-sensitive sorting
No, the sort is based on the use of the standard character set which has a hierarchy of code numbers for each character. The only thing you can do is be consistent with the way you make entries.CACFla wrote:I was wondering if there was a way to override the case-sensitive sorting. For instance when I view posted transactions and am looking for ACME Co it shows up in a different area of the list than Acme Co.
Thank you.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: Case-sensitive sorting
That is what I was afraid of, but with more than one person doing input it doesn't always come out exactly the same.
I suppose my next question is: How can I change a previous entry so that the case matches?
Thank you,
Kathleen
I suppose my next question is: How can I change a previous entry so that the case matches?
Thank you,
Kathleen
Re: Case-sensitive sorting
The easiest way to do this is to do this before its posted, otherwise you would have to reverse the original entry, then add it back in. Not exactly an easy task.CACFla wrote:That is what I was afraid of, but with more than one person doing input it doesn't always come out exactly the same.
I suppose my next question is: How can I change a previous entry so that the case matches?
Thank you,
Kathleen
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
-
- Tech Support
- Posts: 3006
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Case-sensitive sorting
We have written this up as a bug and it will be fixed in the next Maintenance Release for Versions 11 and 11.5.
Re: Case-sensitive sorting
I've never noticed it to be any other way, then again ... I'm fairly consistent with data entry ...Zorak wrote:We have written this up as a bug and it will be fixed in the next Maintenance Release for Versions 11 and 11.5.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: Case-sensitive sorting
Thank you for addressing the issue. I do my best to be consistent, but I'm not the only person that does the entries. I'll be so happy that it will be changed, thank you!
-
- Posts: 320
- Joined: Sun Sep 28, 2003 5:37 pm
- Location: First Cutlerville Christian Reformed Church
- Contact:
Re: Case-sensitive sorting
I have set up rules for entering names because we have a lot of Dutch names in our denomination.
We have names spelled such as Vandenbosch, Van Den Bosch, Van den bosch, Vanden Bosch and all sorts of patterns. These names will come on a report out of alpha order. The old telephone books had it figured out in that they would somehow save the name, take out all the spaces and uppercase letters and then sort, then restore the namefield and print. I haven't seen this addressed in v11.5 that we use. Is this fixed in v.12?
Thanks.
We have names spelled such as Vandenbosch, Van Den Bosch, Van den bosch, Vanden Bosch and all sorts of patterns. These names will come on a report out of alpha order. The old telephone books had it figured out in that they would somehow save the name, take out all the spaces and uppercase letters and then sort, then restore the namefield and print. I haven't seen this addressed in v11.5 that we use. Is this fixed in v.12?
Thanks.
-
- Tech Support
- Posts: 3006
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Case-sensitive sorting
If the issue you have is not with uppercase letters coming before lowercase letters in an alpha sort, but rather that PowerChurch is sorting literally on the text that was entered, that has not been changed.
This is the literal sort that should be happening, regardless of case.
Van Den Bosch
Vanden Bosch
Vandenbosch
This is the literal sort that should be happening, regardless of case.
Van Den Bosch
Vanden Bosch
Vandenbosch
-
- Posts: 320
- Joined: Sun Sep 28, 2003 5:37 pm
- Location: First Cutlerville Christian Reformed Church
- Contact:
Re: Case-sensitive sorting
Thanks Zorak,
What you say is true. Our issue is that:
Tyler Van Den Bosch prints before
Gene Vanden Bosch prints before
Abe Vandenbosch
I take all spaces out and lower case all but the first letter of the last and first names of the Household Key. Seems to work for us.
What you say is true. Our issue is that:
Tyler Van Den Bosch prints before
Gene Vanden Bosch prints before
Abe Vandenbosch
I take all spaces out and lower case all but the first letter of the last and first names of the Household Key. Seems to work for us.