Choose Language Hide Translation Bar
Highlighted
NewtoJMP
Level I

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 )
	)
);
1 REPLY 1
Highlighted
txnelson
Super User

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 )
	)
);
Jim
Article Labels

    There are no labels assigned to this post.