248192_en-US

liliconcom

How to create a case insensitive data filter

Hi everyone!

I am using data filter to select where column value match given text value. How can I make my search case insensitive. Any helps is greatly appreciated. 

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" ) << Data Filter(
 Add Filter(
  columns( :Name ),
  Where( :Name == {"tim", "Patty", "KATIE"} ),
  Display( :Name, Size( 160, 225 ), List Display )
 )
);

Re: How to create a case insensitive data filter

Here is how I would approach the issue

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" ) << Data Filter(
 Add Filter(
  columns( :Name ),
  Where( Uppercase(:Name) == {"TIM", "PATTY", "KATIE"} ),
  Display( :Name, Size( 160, 225 ), List Display )
 )
);