Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Pattern Count that is Case sensitive

Featured Replies

  • Newbies

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.

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.

  • Author
  • Newbies

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?

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

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.