Search Unity

  1. Welcome to the Unity Forums! Please take the time to read our Code of Conduct to familiarize yourself with the forum rules and how to post constructively.
  2. Unite 2023 Registrations are now LIVE! We are thrilled to announce that Unite 2023 Registration is now live and open for all!
    Dismiss Notice
New Forum User Notice Unite 2023 Registrations are now LIVE!

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:
    51
    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.
     
    TCYeh, Apr 10, 2023
    #1

  2. karl_jones

    karl_jones

    Unity Technologies

    Joined:
    May 5, 2015
    Posts:
    7,757
    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
    karl_jones, Apr 11, 2023
    #2
    TCYeh likes this.

  3. TCYeh

    TCYeh

    Joined:
    Jul 25, 2022
    Posts:
    51
    It works! Thank you a lot!
     
    TCYeh, Apr 12, 2023
    #3
    karl_jones likes this.