Skip to content

Instantly share code, notes, and snippets.

@MarissaJ

MarissaJ/number-of-times-item-appears-in-column.js

Last active August 24, 2022 02:01
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save MarissaJ/8dba98a5d9bb0ee6da3b4b162884299e to your computer and use it in GitHub Desktop.
Save MarissaJ/8dba98a5d9bb0ee6da3b4b162884299e to your computer and use it in GitHub Desktop.
Download ZIP
Display number of times an item appears in a spreadsheet column
Raw
number-of-times-item-appears-in-column.js
values = [];
item=thisComp.layer("data 01").text.sourceText.toString();
for(i=0;i<=thisComp.layer("state-gradient.csv")("Data")("Number of Rows")-1;i++) {   
  values.push(thisComp.layer("state-gradient.csv")("Data")("Outline")("Data")("Data " + i).value);
}
values.filter(function(value){
return value === item;
}).length
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment