Skip 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.

Random record selection from file

Featured Replies

  • Newbies

Need to be able to extract from a selected set of records from large file random records and create another file from the selected records.

Will use this function from time to time with different total records expected i.e. need 4000 random records from the universe and another time would need 8200 records etc.

TIA

  • 2 weeks later...

GoToRecord script step as defined by a calculation. Make calculation Random * get ( foundcount ) will send you randomly to a record in your current found set. May need a round in there to get is working, I've not tested.

If you want to create sets of random records and avoid duplicates, you'll need to do a bit more. A simple way to do what you describe would be to create a script that first shows all records, then goes into a loop that runs X number of times, each iteration doing a GoToRecord randomly as Dkemme described above, followed by an Omit Record. Then after the loop exits, do a Show Omitted, and you have a found set of X random records. Then export/print/whatever the resulting found set.

Apologies if this is obvious to you, your profile doesn't show a skill level, and it sounded like you were looking for a full algorithm.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.