Search Unity

  1. We are migrating the Unity Forums to Unity Discussions. On July 12, the Unity Forums will become read-only.

    Please, do not make any changes to your username or email addresses at id.unity.com during this transition time.

    It's still possible to reply to existing private message conversations during the migration, but any new replies you post will be missing after the main migration is complete. We'll do our best to migrate these messages in a follow-up step.

    On July 15, Unity Discussions will become read-only until July 18, when the new design and the migrated forum contents will go live.


    Read our full announcement for more information and let us know if you have any questions.

Question How to include " in the string of CSV file?

Discussion in 'Localization Tools' started by TCYeh, Apr 10, 2023.

  1. TCYeh

    TCYeh

    Joined:
    Jul 25, 2022
    Posts:
    55
    Hi everyone,
    I'm trying to import CSV files to the string tables. But the strings include double quotation marks failed to be imported and pop up "BadDataException: You can ignore bad data by setting BadDataFound to null." error.

    I've tried using \", but it's not working.

    How can I include double quotation marks in the string?
    Thank you in advance.
     
  2. karl_jones

    karl_jones

    Unity Technologies

    Joined:
    May 5, 2015
    Posts:
    8,570
    If you are editing the csv file by hand then you need to add double quotations ("")

    E.G
    This contains "quoted" text => "This contains ""quoted"" text"
    "Some Text" => """Some Text"""

    If you are unsure, then add the quotes in the table editor and export them to CSV through the table editor, it will generate the correct quotation formatting for you.
     
    Last edited: Apr 11, 2023
    TCYeh likes this.
  3. TCYeh

    TCYeh

    Joined:
    Jul 25, 2022
    Posts:
    55
    It works! Thank you a lot!
     
    karl_jones likes this.