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.

Performing multiple pattercounts from a value list/related table at once.

Featured Replies

  • Newbies

Following on from this:-

http://fmforums.com/forum/showtopic.php?tid/217835/

I have a table containing several thousand DNA sequences (single strings of ATCG) and I want to search for the number of times any short string of ATCG occurs in the DNA. Thats all sorted for using pattercount.

Now though I want to create families of the search strings (containing maybe <50) and get the total number of pattercounts for the family.

The families can be in Value lists or as separate tables for each family it doesn't matter.

After some searching I tried:-

PatternCount(text;List(Family1::Searchstring)) where the search strings are in a related table but this doesn't work.

Thanks.

You could loop through each item in the family, performing a patterncount for each of them separately, and add up the total found count.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.