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.

Find text in text string using value list

Jerry100
in Calculation Engine (Define Fields)

Featured Replies

I have inherited a database with six text fields each of which can have one of 30 two letter values. I would like to combine (concatenate) the values for each record into a new field and then perform a find for a specific value within the newly constructed field. I am not sure if one of the FM Text Functions can search a string and find a pattern. Any help would be appreciated. I may be wrong but this seemed a better option than constructing a dynamic find on each of the original six fields.

Why do you keep six similar fields in the same record, instead of six related records in another table?

If I am understanding your requirement, I think you want

not IsEmpty(FilterValues(

List(field1;field2;field3;field4;field5;field6);

"AB")

to return a true value if the code "AB" is in one of the six fields.

If this isn't exactly what you seek, maybe it will get you closer.

Create an account or sign in to comment

https://fmforums.com/topic/71837-find-text-in-text-string-using-value-list/
Go to topic listing

Important Information

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

I accept

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.