Get Line from file, search & place in table

[emperorjones]

Not sure if zenno can do this...

I want to take a line from a list of emails I have and then have zenno search a table for the matching domains and if there is a match, add the email to a cell in the table.

So for example, the list reads:

1. [email protected]
2. [email protected]
3. [email protected]

and the table has a row with three columns that contains this data:

1. DoctorName; Address; http://www.mydoctor.com; [blank cell]

I'd like to take a line from the list and check each row from the table and see if it matches the domain in column 3 (www.mydoctor.com), if it does, I'd like to write it into row 1, cell 4.

Is this possible?

 

[lokiys]

Not sure if zenno can do this...

I want to take a line from a list of emails I have and then have zenno search a table for the matching domains and if there is a match, add the email to a cell in the table.

So for example, the list reads:

1. [email protected]
2. [email protected]
3. [email protected]

and the table has a row with three columns that contains this data:

1. DoctorName; Address; http://www.mydoctor.com; [blank cell]

I'd like to take a line from the list and check each row from the table and see if it matches the domain in column 3 (www.mydoctor.com), if it does, I'd like to write it into row 1, cell 4.

Is this possible?

Hi. Sure it is possible, and if honestly I do not have anything other to suggest as making it by plan You have already told.
Check list and table processing in wiki if you do not know anything about it and go ahead You can post some screenshots of what You have done if something is not working
https://zennolab.com/wiki/en:list
https://zennolab.com/wiki/en:table

Thanks

 

[emperorjones]

Thanks lokiys. I guess i can do this lol. I already have a file that searches a list for specific text. I search the forum and found code for searching a table for specific text and fount this:

We need to check if there is a cell that contains a specific text.
It can be solved using this C# macro (in the attached project, we are searching a cell that contains "Mexico")
Code (javascript):

1. 
   
2. // take text for search from a variable
3. var textContains = project.Variables["tableSearchTextContains"].Value;
4. // get table for search
5. var sourceTable = project.Tables["SourceTable"];
6. // search in each row
7. lock(SyncObjects.TableSyncer)
8. {
9. for(int i=0; i < sourceTable.RowCount; i++)
10. {
11. // read a row (array of cells)
12. var cells = sourceTable.GetRow(i).ToArray();
13. // loop through all cells
14. for (int j=0; j < cells.Length; j++)
15. {
16. // check if cell contains specified text, if there are matches return "yes"
17. if (cells[j].Contains(textContains))
18. return "yes";
19. }
20. }
21. }
22. // if nothing found return "no"
23. return "no";

How would I change this so that if "yes" it writes/appends the variable in the appropriate cell?