Check list for data in PM

[emperorjones]

Is it possible in PM to have ZP load a list, check each line for data against a variable and report back whether or not the data exists?

Thanks.

 

[lokiys]

Sure the best and fastest way is to use C#
http://zennolab.com/discussion/threads/search-in-list-and-tables-via-c-macro.10733/

// take search text from variable
var textContains = project.Variables["listSearchTextContains"].Value;
// get a list or search
var sourceList = project.Lists["SourceList"];
// search in each line of list
lock(SyncObjects.ListSyncer)
{
    for(int i=0; i < sourceList.Count; i++)
    {
        // get line from list
        var str = sourceList[i];
        // check if line contains text, if there are matches return "yes"
        if (str.Contains(textContains))
            return "yes";
    }
}
// ifnothing found return "no"
return "no";

 

[emperorjones]

Thanks!!, i guess now I finally have to learn how to use C#

 

[emperorjones]

So if my variable is "City" and my list is "MasterCityList"

Does it look like this?

// take search text from variable
var textContains = city.Value;
// get a list or search
var sourceList = MasterCityList;
// search in each line of list
lock(SyncObjects.ListSyncer)
{
for(int i=0; i < sourceList.Count; i++)
{
// get line from list
var str = sourceList;
// check if line contains text, if there are matches return "yes"
if (str.Contains(textContains))
return "yes";
}
}
// ifnothing found return "no"
return "no";

 

[rostonix]

You should change only name of list
project.Lists["MasterCityList"];
the same is for variable

 

[emperorjones]

I see. simple - Thanks!!