topic Re: Case Insensitive searches using contains in Discussions

Case Insensitive searches using contains

ENTHU — Thu, 31 Jan 2019 12:28:29 GMT

I am using the following piece of code to check if the list cn contains "col_name" and if yes rename it as Target.The problem is col_name can be all upper case or lowercase and there is no way for me to control that.How do I make sure that the code gets executed irrespective of the case?

If( Contains( cn ,Lowercase("col_name") ),  


:"col_name" << Set name("Target");

);

Thanks

Re: Case Insensitive searches using contains

gianpaolo — Thu, 31 Jan 2019 13:00:34 GMT

hello,

i think you can apply "substitute" ... follow the below example

Names Default To Here( 1 );

lst = {"a", "lowercase", "c"};

Substitute( lst, "lowercase", "Target" );

ciao

Gianpaolo

Re: Case Insensitive searches using contains

txnelson — Thu, 31 Jan 2019 13:06:19 GMT

What is "cn"? A List, a String, an Associative Array???
Is "col_name" supposed to be referring to the name of a column?

Please provide more specifics

Re: Case Insensitive searches using contains

pmroz — Thu, 31 Jan 2019 14:22:54 GMT

There's no need to use lowercase() on col_name because it's already in lowercase. This code will do what you want:

dt = New Table( "Untitled 2", Add Rows( 1 ),
	New Column( "COL_Name", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [1] ) ),
	New Column( "Column 2", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [2] ) ),
	New Column( "Column 3", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [3] ) )
);
cn_list = dt << get column names(string);
for (i = 1, i <= nitems(cn_list), i++,
	cn_list[i] = lowercase(cn_list[i]);
);

If( Contains( cn_list, "col_name" ),
	:"col_name" << Set name("Target");
);

Re: Case Insensitive searches using contains

jay_holavarri — Tue, 15 Nov 2022 11:29:58 GMT

For the record, a couple times a year this case sensitivity with Contains() bugs me. It may be a personal problem, but I dislike having to add that For loop to make a list all upper or lower case for future use with Contains(). I wish Contains had a case sensitivity option.

My preferred method is this to force the case for all items in a list:

myList = {"Steelers", "Falcons", "rams", "SeaHawks"};
myNewList = Words(Upper Case(Concat Items(myList)));

Cheers