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.

Highlighting An Alpha-Numeric Record From A List

Daniel Shanahan
in Conditional Formatting

Featured Replies

I am trying to highlight a record in a portal where the portal record ID (departmentsFL::ID) = an ID in a global field list (VIEWER_vwr::highlight_g). The IDs are alpha-numeric. I used this:

PatternCount ( VIEWER_vwr::highlight_g ; departmentsFL::ID )

This is flawed because the ID DEP1 and DEP11 are both true for PatternCount(). How can I scan a list of text and check for unique text and numbers?

Thanks.

How about =

VIEWER_vwr::highlight_g = departmentsFL::ID

If VIEWER_vwr::highlight_g contains a list of values, then I think this is what you are looking for

not IsEmpty( FilterValues( VIEWER_vwr::highlight_g ; departmentsFL::ID ) )

If VIEWER_vwr::highlight_g contains a list of values

Good point.

  • Author

As I was searching, I came across this 

PatternCount ( "¶" & <Value List Items> & "¶" ; "¶" & <Search Value> & "¶" )

This works. Now, when I search for DEP11 in the list I find only DEP11 and not DEP1.

Why does this work? With the carriage returns, the PatternCount() returns 1. Without the carriage returns, it returns 2. Can anyone clarify/enlighten?

Thanks.

  • Author

Thanks, comment and dansmith65. I didn't notice your comments until after my follow-up comment.

@dansmith65 - yes, that seems to do the trick. Thanks.

Can anyone clarify/enlighten?

Well, "DEP1" is contained in "DEP11". So:

PatternCount ( "DEP1¶DEP11" ; "DEP1" )

returns 2, because "DEP1DEP11" contains two occurrences of "DEP1".

  • Author

Well, "DEP1" is contained in "DEP11". So:

PatternCount ( "DEP1¶DEP11" ; "DEP1" )

returns 2, because "DEP1DEP11" contains two occurrences of "DEP1".

Right, but why does adding a carriage returns to the beginning and end of the list as well as the beginning and end of the value change that?

Adding carriage returns to "DEP1" changes it to "¶DEP1¶". Neither "DEP11" nor "¶DEP11¶" contain the modified pattern.

You need to wrap the value list in carriage returns as well - otherwise the first and the last values in the list will not match the searched value.

  • Author

Adding carriage returns to "DEP1" changes it to "¶DEP1¶". Neither "DEP11" nor "¶DEP11¶" contain the modified pattern.

And the lightbulb goes on. Thanks, comment. That makes sense.

Create an account or sign in to comment

https://fmforums.com/topic/75360-highlighting-an-alpha-numeric-record-from-a-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.