Thanks fellas, I'm making progress. And thank you for the color coding
, it helps tremendously!
Now I think the last is still to combine counts. The above examples work close, but aren't getting exactly what I'm looking for.
To help explain, here's an example of what I'm doing, and what I'm looking for. As you can see, my data is columned, with space values where appropriate. Using pietzcker' example, I can search a column and count the populated fields. In this case "4" is correct:
So I then go through and do the rest of the columns as well, and add them up (in this case, 4 + 4 + 2 + 1 = 11).
However, as I have 200 columns to search in 60 files, I would like to have a string that sums (a file at a time) this way:
When I try mofi's example, it seems to stop at the first column count. Maybe because I have space values between the columns I want to count?