​@Rohit_809 Kumar Have you tried matches 
 

vals = l"preSomeName", "SomeNamepost", "other"];

matchTest = s"pre*", "*post"];

foreach v in vals
foreach m in matchTest
select { v: v, m: m, r: matches(v, m) }

​@Rohit_809 Kumar There will be a few ways to handle this.  Gary mentioned on.  I’ll try to show another

You could use an “if” statement to make adjustments to the server names.

let serverName = if matches(match.data.server, “Inte*”)

                                   then suffix(match.data.server, length(match.data.serve) - 4)

                                  else match.data.server

This way only if the server name starts with “Inte” then you will use the “suffix” function to but of the “Inte” letters.  If it does not start with “Inte” then you don’t need to do anything.

This function suffix(match.data.server, length(match.data.serve) - 4).  The thing here is that I don’t know how long the full server name is.  So I use “length(match.data.serve) - 4” to say that starting from the back end of the server name, show me all but the first 4 characters.