Creative Communities of the World Forums

The peer to peer support community for media production professionals.

Activity Forums Adobe After Effects Expressions How turn specific data from .csv file into sourceText property?

  • How turn specific data from .csv file into sourceText property?

    Posted by Mikael Holmström on February 26, 2019 at 2:23 pm

    Hi,

    I’m trying to understand the data-driven animation feature in After Effects. More specifically, how to parse the .csv format (easily exported from Numbers or Excel) and convert it’s data to, let’s say the sourceText property of a text layer.

    This is how my “test.csv” file, that is imported to my project and comp, reads when exported from Numbers:

    ;
    wind;10
    temperature;12

    Can someone please help me with an expression that turns the sourceText of a text layer into the value of “wind”?

    Thanks,
    Mikael

    Oleg Pirogov replied 7 years, 5 months ago 2 Members · 1 Reply
  • 1 Reply
  • Oleg Pirogov

    March 1, 2019 at 7:38 am

    CSV is auto-parsed from something like this:
    words, numbers
    wind, 10
    temperature, 12

    to this:

    And “value of wind” is obtained through the following expression for sourceText:
    thisComp.layer("testCsv.csv")("Data")("Outline")(" numbers")(" numbers 0")

    Not quite understand what went wrong in your case,= as well as why are there semi-=colons in your comma-separated file.

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