Search Unity

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

  2. karl_jones

    karl_jones

    Unity Technologies

    Joined:
    May 5, 2015
    Posts:
    8,292
    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:
    55
    It works! Thank you a lot!
     
    TCYeh, Apr 12, 2023
    #3
    karl_jones likes this.