518447_en-US

liliconcom

Wild card for Match function

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

 

 

Scripting