Doubt about table

[Jaseel s]

Hello,
I have 2 columns in my table which column 1 contains 'Name of countries' and column 2 contains 'Capital cities of corresponding coundries' .

I need to get the coundry name when we call its capital.
I also have list of coundries and list of capitals in the same order.

Please help to solve this

 

[PHaRTnONu]

// take text for search from a variable (just the name of the varible not the whole {-variable. you want whats after the . 
var textContains = project.Variables["///NAME-OF-VARIBEL-HERE///"].Value;
// get table for search replace whats in the pathereses with the naem of the table in PM
var sourceTable = project.Tables["///TABLE-NAME-HERE///"];
// search in each row
lock(SyncObjects.TableSyncer)
{
  for(int i=0; i < sourceTable.RowCount; i++)
  {
  // read a row (array of cells)
  var cells = sourceTable.GetRow(i).ToArray();
  // loop through all cells
  for (int j=0; j < cells.Length; j++)
  {
  // check if cell contains specified text, if there are matches return "yes"
  if (cells[j].Contains(textContains))
  return i;
  }
  }
}
// if nothing found return "no"
return "no";

result is the row number.
second block after is
table processing
in row you put something like {-Variable.LookupResult-}
or what ever you made the result for the c# code
and then the corresponding column you want

 

[Jaseel s]

Works like a charm

 

[PHaRTnONu]

Works like a charm

glad it worked