topic Wild card for Match function in Discussions

Wild card for Match function

Mickyboy — Fri, 09 Jun 2023 17:03:33 GMT

Hi Everyone,

I had a variable "medium" and l needed a grouping variable so i created another variable for the grouping "EMEM Medium" and below if the code i used to populate the new variable.

Match( :Medium,
	"Standard", "Standard",
	"Standard 1", "Standard",
	"Standard 2", "Standard",
	"Standard 3", "Standard",
	"Standard 4", "Standard",
	"Standard 5", "Standard",
	"Standard 6", "Standard",
	"Sigma", "Sigma",
	"Sigma 1", "Sigma",
	"Sigma 2", "Sigma",
	"Sigma 3", "Sigma",
	"Sigma 4", "Sigma",
	"Sigma 5", "Sigma",
	"Sigma 6", "Sigma",
         "else", -9999)

just wondering if there is wildcard l could have used, or a different approach, to make the syntax a little more compact and readable.

Thanks

Mick

Re: Wild card for Match function

Georg — Thu, 07 Jul 2022 06:19:37 GMT

I think it's not possible with match, see:

Match (jmp.com)

But you can uses word in this case, it's much simpler:

Names Default To Here( 1 );

dt = New Table( "test",
	New Column( "Medium","Character",
		set values(
			{"Standard", "Standard 1", "Standard 2", "Standard 3", "Standard 4", "Standard 5", "Standard 6", "Sigma", "Sigma 1", "Sigma 2", "Sigma 3",
			"Sigma 4", "Sigma 5", "Sigma 6"}
		)
	)
);

dt << New Column( "Match", "Character",
	formula(
		Match( :Medium,
			"Standard", "Standard",
			"Standard 1", "Standard",
			"Standard 2", "Standard",
			"Standard 3", "Standard",
			"Standard 4", "Standard",
			"Standard 5", "Standard",
			"Standard 6", "Standard",
			"Sigma", "Sigma",
			"Sigma 1", "Sigma",
			"Sigma 2", "Sigma",
			"Sigma 3", "Sigma",
			"Sigma 4", "Sigma",
			"Sigma 5", "Sigma",
			"Sigma 6", "Sigma",
			"else", -9999
		)
	)
);

dt << New Column( "Word", "Character",
	formula(
word(1, :Medium)
	)
);

Re: Wild card for Match function

jthi — Thu, 07 Jul 2022 09:33:06 GMT

JMP can also create the Word column shown by @Georg interactively (might need some additional handling for non-matches).

Right click on column header and create new formula column:

or use recode:

Re: Wild card for Match function

Mickyboy — Thu, 07 Jul 2022 23:28:46 GMT

Brilliant, thank you Georg, also thank you to jthi, appreciate the replies, thank you both