Value List In Calculation

[itsalljustaride]

I'm trying to use the values entered in a "Ignore Words" value list during a calculation to set a catalog number for film titles (for example, ignoring words like "the" and "a"). I would assume I would use the ValueListNames function, but not sure how exactly it works. How do I test if a text string is in that value list? I tried something along the lines of

If firstword = ValueListNames( Get (Filename); 'Ignore Words List")

But that didn't go so well. Any thoughts?

[Fitch]

Try this:

Case ( Position ( ValueListNames( Get (Filename); "Ignore Words List") ; firstword ; 1 ; 1 ) )