topic Re: Case Insensitive searches in Discussions

Case Insensitive searches

Hegedus — Tue, 05 May 2015 17:34:32 GMT

Hi,

Most JMP is case insensitive except when it comes to text values.

Since text data is often messy and case is one way it shows up, is there a way to do case insensitive versions of Contains?

Re: Case Insensitive searches

Craige_Hales — Thu, 31 Jan 2019 12:16:56 GMT

regex is case sensitive by default, PatMatch is insensitive by default.

regex("The Quick Brown Fox", "quick", "\0", IGNORECASE);
"Quick"

regex("The Quick Brown Fox", "quick", "\0");
returns missing

rc = PatMatch("The Quick Brown Fox", patPos()>>where + "quick">>what);
show(rc,where,what);
rc = 1;
where = 4;
what = "Quick";

PatMatch("The Quick Brown Fox", patPos()>>where + "quick">>what, NULL, MATCHCASE);
returns 0

Regex

Re: Case Insensitive searches

Melanie_J_Drake — Thu, 31 Jan 2019 12:17:23 GMT

If you want to specifically use Contains(), you can use Lowercase() or Uppercase() to perform case-insensitive searches:

str1 = "Hello";
str2 = "ELL";

Contains( Lowercase(str1), Lowercase(str2) );

Contains( Lowercase(str1), "ell" );

Contains( Lowercase(str1), Lowercase("Ell") );

Re: Case Insensitive searches

Craige_Hales — Wed, 09 Nov 2016 10:02:43 GMT

more information on case and regex: Back Reference

Re: Case Insensitive searches

tim_reeves — Tue, 19 Oct 2021 17:17:07 GMT

this was helpful to me and I think it should be mentioned in the Help for the Contains function, which does not even mention that the function is case-sensitive.

Re: Case Insensitive searches

ErraticAttack — Tue, 19 Oct 2021 19:15:14 GMT

If you're trying to find a matching item in a list of strings (say column titles) and you want to match JMP's default of ignoring case / spaces, you can use the As Name function, see below

Names Default to Here( 1 );

list = {"Height", "Weight", "CamelCase", "__Dunder_Mifflin__" };

Show( Contains( list, "camel case" ) ); // 0

named list = {};
For( i = 1, i <= N Items( list ), i++,
	named list[i] = As Name( list[i] )
);

Show( Contains( named list, As Name( "camel case" ) ) ); // 3