Skip to main content
Solved

Find a specific word from a "Array Join" field.

  • July 13, 2023
  • 2 replies
  • 21 views
A
Forum|alt.badge.img+17

Seeking to identify if two numbers match exactly in both fields, such as 22 matching 22, and not partial matches like 2.

 

 

Best answer by Sho

How about REGEX?

REGEX_MATCH(ARRAYJOIN({Above 20%}),"(^|,)"& {Hours Number} &"(,|$)")

2 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • Answer
  • July 13, 2023

How about REGEX?

REGEX_MATCH(ARRAYJOIN({Above 20%}),"(^|,)"& {Hours Number} &"(,|$)")
TheTimeSavingCo
A
Forum|alt.badge.img+17
  • Abraham_Bochner
  • Author
  • Known Participant
  • July 13, 2023

How about REGEX?

REGEX_MATCH(ARRAYJOIN({Above 20%}),"(^|,)"& {Hours Number} &"(,|$)")

Thank you greatly, this is precisely what I aimed to achieve.

Terms & ConditionsAccessibility statement