Pattern Count that is Case sensitive

[DMouse]

Is there a way to do a case sensitive pattern count? Example find a count of all the uppercase A's in the name field.

[Vaughan]

Thye Substitute() function is case sensitive. Perhaps you could use Substitute() to change the capital A to something unique (like "*A*) then do a PatternCount for the new string.

[DMouse]

Yes, that will work. Thank You.

My files involve thousands of records and I was hoping for a quicker solution but it looks like there isn't one.

I will tell you exactly what I am trying to do and maybe you will have some ideas. I am exporting data from Filemaker and importing it into Quark. Once I get the data into Quark if a record is two long for one line my program will split it into two lines with a shift return. I use three different fonts & point sizes per line so simply counting characters isn't always 100%. What I was looking at doing was assigning a value to each character in Filemaker based on the width of the letter itself in relation to the individual fonts and point sizes and in Quark if the line value was over say a 100 put a shift return in the correct place. The pattern count would work except for not being case sensitive as an uppercase A takes up more space than a lowercase a. My other idea may be to count the number of words in a field and as each word is uppercase adding a value of one or two for each word. This may not be much accurate than what I am doing now, however.

Any better ideas?

[Vaughan]

Surely Quark has automated styles that can perform this sort of formatting? This sort of thing is not FMP's strongest area.