record to empty colum

[PHaRTnONu]

how do i record to a designated row's first empty column?
some are like 3 colums full other are like 2 or 30...
i just need to add data to the NEXT empty column

 

[VladZen]

This is a task for logic. You should get value of cell in a row and compare it with empty string.

 

[PHaRTnONu]

This is a task for logic. You should get value of cell in a row and compare it with empty string.

I already have row. is it just like
get column=!''
?

 

[VladZen]

I already have row. is it just like
get column=!''
?

I think, yes. You should try.

 

[PHaRTnONu]

// take text for search from a variable
var textContains =!'';
// get table for search
var sourceTable = project.Tables["SourceTable"];
// search in each row
lock(SyncObjects.TableSyncer)
{
  for(int i=0; i < sourceTable.ColumnCount; i++)
  {
  // read a row (array of cells)
  var cells = sourceTable.GetColumn(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";

wont run

 

[PHaRTnONu]

fail

if i would have just done record to cell in Table processing in zenno you can just put a value of "-1" and it will record to the last unused cell for the row you decide

that was much simpler