Problem with CSV file in After Effects

Question

Good morning to everyone! I have the following problem ... I have this simple CSV file.   I open it and with a notebook so you can see the data it has.  I enter the CSV file in After Effects and connect a text to get the data from the CSV file. Inserts all the data from the row, without space, and displays the symbol ;   How can I choose to display only one item (eg name)  from the row and don't see the symbol ; I try to change the expression but... &#128542;  I attach the demo CSV file and the expression thisComp.layer("TEST.csv")("Data")("Outline")("No;Name;Surname")("No;Name;Surname 0") Thank you in advancebest wishesJohn K.

Mylenium · Answer

Well, a semikolon is not a comma as required in a "Comma Separated Values File" (CSV). And the real truth here is that it has nothing to do with AE. This is one of those unique quirks in Excel which will use the system default delimiter internally or on export. You can change that in Excels settings itself (disable the "Use system settings" option and define your own delimiter) or on the system level in your language and region settings. Of course there would be ways to filter out the characters after the fact as well, but technically this doesn't help you with your current conundrum.

Mylenium

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded