Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Activity Forums Adobe After Effects Passing layer sourceText into double quotes of an expression?

  • Passing layer sourceText into double quotes of an expression?

    Posted by Andrew Marston on June 23, 2020 at 4:17 pm

    I’m building a template to display data from a csv. The user will type the name of a column into a text layer, and this string is passed into the expression to display data from this column. However I can’t figure out how to pass the sourceText of the text layer into the csv reference expression. I suspect I’m just using double and single quote wrong, but can’t seem to get it. Any idea how to pass a string into the double quotes of an expression?
    colName = thisComp.layer("Type Col Name Here").text.sourceText;
    thisComp.layer("Population2019.csv")("Data")("Outline")("'colName'")("'colName'" + " 0").value);

    Andrew Marston replied 5 years, 10 months ago 2 Members · 3 Replies
  • 3 Replies
  • Robert Müller

    June 24, 2020 at 10:34 am

    Hi Andrew,
    No quotes for variables my friend ?
    colName = thisComp.layer("Type Col Name Here").text.sourceText;
    thisComp.layer("Population2019.csv")("Data")("Outline")(colName)(colName + " 0").value);

  • Andrew Marston

    June 24, 2020 at 5:31 pm

    I see. The final expression referencing the CSV seems to need quotes to navigate the data tree. When I try with and without quotes I get an error though. :-/ Here’s a screenshot of a stripped version of this section of the project:

  • Andrew Marston

    June 24, 2020 at 5:36 pm

    Oh! Nevermind. After removing the quotes from the source text and fiddling with how I was adding the space+i I was able to get it. For anyone who find this with a similar question, here’s a screenshot of the final code that’s working:

We use anonymous cookies to give you the best experience we can.
Our Privacy policy | GDPR Policy