Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[8139david]

I have the custom field, Original Language, with possible values: fr, en, ja, ko, pl, zh, ...
How can I test if its value for a given movie is ja, ko or zh (ie is any of these 3 values)?
I want a custom expression that separates the movies with ja, ko or zh as value from all the others.

[8139david]

Well, I found this way:

Code: [Select]

isequal(jakozh, [Original Language], 8)

[RoderickGI]

That will work but will also match if the [Original Language] is "ak" or "oz".

Take a look at the IfElse command. That can be more specific.

[blgentry]

Regex was designed for these types of tests:

http://wiki.jriver.com/index.php/String_Manipulation_Functions#Regex

This is untested, but something like:

regex([Original Language],/#ja|ko|zh#/)

That should give a 1 for true and a 0 for false.

Brian.