INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Expressions: Most efficient way to do a logic "OR" with CONTAINS-like function?  (Read 1356 times)

Quixote

  • Regular Member
  • World Citizen
  • ***
  • Posts: 158
  • Change this by choosing profile
Expressions: Most efficient way to do a logic "OR" with CONTAINS-like function?
« on: June 15, 2015, 04:25:30 pm »
I'm wanting to do a check on lyrics for Explicit content. (I know I can also do this using a Search list, however, I need to do this as an expression.)

Questions:
  • What is the best practice way for searching a list of words/phrases in a tag?
  • Is MATH( | ) the appropriate way to do an "OR" in an expression?
  • Would a regular expression perform better or be more flexible?

What I've come up with so far is to identify "witch" and " ass " in Lyrics:

Code: [Select]
=If(Math(IsEqual([Lyrics],witch,8)|IsEqual([Lyrics],/ ass/ ,8))
    ,explict
    ,clean)

Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: Expressions: Most efficient way to do a logic "OR" with CONTAINS-like function?
« Reply #1 on: June 15, 2015, 05:49:41 pm »
Assuming you really mean within the Expression Language, see:
http://wiki.jriver.com/index.php/Expression_Language#Conditional_Functions
and
http://wiki.jriver.com/index.php/Boolean_Operations

The Search Language, however, supports OR type operations directly:
http://wiki.jriver.com/index.php/Search_Language#Grouping_and_Combining
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

ferday

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1732
Re: Expressions: Most efficient way to do a logic "OR" with CONTAINS-like function?
« Reply #2 on: June 15, 2015, 06:12:32 pm »
Probably regex

ifelse(regex([lyrics]/#(witch|ass)/b)#/,0,0),explicit,clean)

Note: I'm learning regex so I've probably missed something, haven't tested...but you can extend the (1|2|3|...) ad infinite
Logged

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
Re: Expressions: Most efficient way to do a logic "OR" with CONTAINS-like function?
« Reply #3 on: June 16, 2015, 01:35:17 am »
If you want to more deeply explore timing of operations you can turn on logging and create your expressions, then run each and check how long they take to run in the log... you can then choose the most optimal...
Logged
Pages: [1]   Go Up
« previous next »