Skip to content

Instantly share code, notes, and snippets.

View MarissaJ's full-sized avatar

FluxVFX MarissaJ

2 followers · 0 following
View GitHub Profile
@MarissaJ
MarissaJ / number-of-times-item-appears-in-column.js
Last active August 24, 2022 02:01
Display number of times an item appears in a spreadsheet column
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
@MarissaJ
MarissaJ / sum-total-data-column.js
Last active August 24, 2022 02:01
After Effects Data Driven Expression- Sum Total Spreadsheet Column Data
rows =thisComp.layer("Data-Sample.csv")("Data")("Number of Rows");
total = 0;
for(i=0;i<rows;i++) {
if(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i))
{
total+= thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i);
}
} total;
@MarissaJ
MarissaJ / column-data-line-break.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- All Column Data with Line Break
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")-1;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Text Data")("Text Data " + i).value);
} values.join("\n");
@MarissaJ
MarissaJ / column-data-with-spaces.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- Display Column Data with Spaces
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")-1;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Text Data")("Text Data " + i).value);
} values.join(" ");
@MarissaJ
MarissaJ / Line-break-control.js
Last active August 24, 2022 02:32
After Effects Data Driven Expression- Line Break Control
row = parseInt(thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")-1);
thisComp.layer("Data-Sample.csv")("Data")("Outline")("Long Text")("Long Text " + row)
txt = thisComp.layer("Data-Sample.csv")("Data")("Outline")("Long Text")("Long Text " + row);
n = effect("Line Break")("Slider");
outStr = "";
newLine = "";
splt = txt.split(" ");
for (i = 0; i < splt.length; i++){
if ((newLine + " " + splt[i]).length > n){
@MarissaJ
MarissaJ / data-based-on-time.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- Display Column Data Based on Time
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")+2;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i).value);
} v=values.join(",");
string=v;
array=string.split(",");
l=array.length;
sec=Math.floor(time/effect("Slider Control")("Slider"));
if(sec<l){
@MarissaJ
MarissaJ / largest-value-column-data.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- Display Largest Value in a Spreadsheet Column
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")+1;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i).value);
}
Math.max.apply(null, values)
@MarissaJ
MarissaJ / smallest-value-spreadsheet-column.js
Last active August 24, 2022 02:10
After Effects Data Driven Expression- Smallest Value in a Spreadsheet Column
values = [];
for(i=0;i<=thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")-1;i++) {   
  values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i).value);
}
Math.min.apply(null, values)
@MarissaJ
MarissaJ / data-row-number.js
Last active August 24, 2022 02:11
After Effects Data Driven Expressions- Display Data Based on Row Number
n=Math.round(thisComp.layer("Data-Sample.csv")("Data")("Number of Rows"));
values = [];for(i=n-1;i<=n-1;i++)
{     values.push(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Text Data")("Text Data " + i).value); }
values;
@MarissaJ
MarissaJ / last-value-in-column.js
Created November 20, 2018 22:43
Get the last entry in a column
rows =thisComp.layer("Data-Sample.csv")("Data")("Number of Rows")+1;
last_val= 0;
for(i=0;i<rows;i++) { if(thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i))
{
Math.max(last_val= thisComp.layer("Data-Sample.csv")("Data")("Outline")("Number Data")("Number Data " + i)); } } last_val;