Space deleted when importing CSV

Community Community & Industry Discussion
, , , ,
1

Hey guys,

I’m trying to import a CSV file exported from MYSQL into the UE4, which is working well except for strings which contains a space (they are truncated).

Here is what I mean, for example for this line of my csv file :

“name”,“craft_fee”,“reagent1”,“reagent2”,“reagent3”,“reagent4”,“reagent5”,“reagent6”,“reagent7”,“reagent8”,“qty1”,“qty2”,“qty3”,“qty4”,“qty5”,“qty6”,“qty7”,“qty8”
“SilverCore_Recipe”,200,“Demon
eye”,“Demon
tooth”,“”,“”,“”,“”,“”,“”,10,25,0,0,0,0,0,0

The result is

107438-csvimportbug.jpg
107438-csvimportbug.jpg819×557 34.2 KB

As you can see, all the strings are truncated, and I don’t understand why because from what I found on the net the syntaxe of my CSV is ok, right?

Thanks for your help

2

Ok nevermind I just found the reason of this. I was using a “Name” type for my strings, I just changed it to Text and it’s now working as intend. I’m leaving the answer here in case it rings the bell of someone else.