An issue with .csv file upload

[Peony]

I've create .csv file with come data (example is below). When I Load this file into the "edit script" the 2-nd and 11th item still stay as string without separating into the columns.

How can I to separate the rows into columns while loading?

Product_Id,Product_Line,Product_category,Product_Subcategory

1,Sporting Goods,Outdoor Recreation,Winter Sports & Activities

2,"Food, Beverages & Tobacco",Food Items,Fruits & Vegetables

3,Apparel & Accessories,Clothing,Uniforms

4,Sporting Goods,Athletics,Rugby

5,Health & Beauty,Personal Care

6,Arts & Entertainment,Hobbies & Creative Arts,Musical Instruments

7,Arts & Entertainment,Hobbies & Creative Arts,Orchestra Accessories

8,Arts & Entertainment,Hobbies & Creative Arts,Crafting Materials

9,Hardware,Tool Accessories,Power Tool Batteries

10,Home & Garden,Bathroom Accessories,Bath Caddies

11,"Food, Beverages & Tobacco",Food Items,Frozen Vegetables

12,Home & Garden,Lawn & Garden,Power Equipment

[Sergey_Shuklin]

Добрый день, Наталья!

Попробовал загрузить Ваш пример из txt - всё хорошо разделяется на колонки. Возможно, в исходном файле есть какой-то скрытый символ, который мешает разделителю. У Вас есть возможность выложить кусочек оригинального файла (с искаженными данными)? Спасибо.

Hello, Nataliia!

I've tried to load you example from txt, and it's work well. May be there is some technical symbol in that rows. Can you please provide a sample of original scrambled data if it's possible? Thank you!

[vishsaggi]

Strange it works find at our end. Can you share you sample csv file.

[Peony]

Доброго дня, Сергей.

Добавила файл к теме.

[Peony]

Hello, Vishwarath.
I have already add an csv example to the topic.

[rubenmarin]

Hi Nataliia, the rows that fails have this content:

"2,""Food, Beverages & Tobacco"",Food Items,Fruits & Vegetables"

The comma that should separate the fields is inside the double quotes, so QV reads this as part of the first field, it should be:

2,"Food, Beverages & Tobacco","Food Items,Fruits & Vegetables"

or

"2","Food, Beverages & Tobacco","Food Items,Fruits & Vegetables"

[Peony]

Can you say, how to definde that there is double quotes in the string, 'cause I see only 11,"Food, Beverages & Tobacco",Food Items,Frozen Vegetables

[rubenmarin · Accepted solution]

Hi Nataliia, do right-click in the file and open it with notepad or any other text editor to see the real content.

Maybe you are openeing this in excel or any other software changes it.

[vishsaggi]

As ruben mentioned if you open it with notepad you see those extra quotes around 2 and 11 rows. Just remove them and it would work fine.

[Peony]

O! Indeed! Thank you, now it's obvious.