Dataclay — Automating Digital Production
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Register
    • Login

    Line breaks with .tsv

    Scheduled Pinned Locked Moved Google Sheets
    2 Posts 2 Posters 37 Views 2 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • chrismeadmoreundefined Offline
      chrismeadmore
      last edited by

      It’s been a while since I used Templater - Previously I’ve linked Google Sheets and I’m sure that line breaks were carried over to AE.

      I’m limited to using .tsv files but the line breaks won’t carry. I cannot use paragraph text layers, I’ve also tried using /n and /r but it doesn’t not work.

      Any advice?

      Jeffundefined 1 Reply Last reply Reply Quote 0
      • Jeffundefined Offline
        Jeff @chrismeadmore
        last edited by

        @chrismeadmore

        Thanks for reaching out to us. You are 100% correct that we can’t use a /n or /r modifier to insert a line break when using a TSV as a Data Source. Instead, we’ll need to use a special character in conjunction with an After Effects Expression.

        For this example, we’ll use an asterisk ( * ) in our Data Source to designate where line breaks should be inserted. So, if we wanted text on two lines, the data would look something like this: “Lorem ipsum*dolor sit amet” (with no quotes).

        Then, we’ll want to add this Expression:

        thisLayer.text.sourceText.split("*").join("\r");
        

        to the Source Text property of the text layer. This should instruct AE to search the text and replace any asterisks it finds with /r, which should result in a line break.

        You can change the asterisk to another character if needed, but hopefully, this should get us moving in the right direction. If you have any other questions or if we can help further, please don’t hesitate to reach out here or to our main support at support@dataclay.com.

        Thanks and Happy Rendering!

        Jeff

        1 Reply Last reply Reply Quote 0
        • First post
          Last post