Using Pattern Count in Conditional Formatting

[Kiele]

Hi experts,

I want to conditional format a field when the field contains a name with extension of .txt, .pdf, .bmp, .gif, .jpg, .png, or .mov.

This one will work, but I'm wondering if there is a better way to write it.

PatternCount ( Test::Uploadnames ; ".JPG" )  or 

PatternCount ( Test::Uploadnames ; ".png" )  or  

PatternCount ( Test::Uploadnames ; ".pdf" )  or  

PatternCount ( Test::Uploadnames ; ".txt" )  or  

PatternCount ( Test::Uploadnames ; ".gif" )

TIA for your kind assistance.

Kiele

[Raybaudi]

ValueCount ( FilterValues ( ".JPG¶.png¶.pdf¶.txt¶.gif" ; Substitute ( Test::Uploadnames ; "." ; "¶." ) ) )

[Kiele]

Hi Daniele,

Thank you for your assistance, it works great.

I modified it for use with a value list, and this is what it look like.

ValueCount ( FilterValues ( ValueListItems ( "Test" ; "ext" ) ; Substitute ( Test::Uploadnames ; "." ; "¶." ) ) )

Thank you again,

Kiele