Hey everyone,
I just want a data export of my client's products.
I have the data feed add on installed called "Google Base" I then navigate to this page and find the "download" button. The outputted file has this in cell A1
id price title link description condition availability image_link gtin brand mpn google_product_category product_type
This is fine, it looks like a tab delimited version - so in excel I can text to columns and split this fine.
However for majority of the fields the description is being split randomly across multiple columns
[attachment=11906:2016-11-30_1406.png]
This causes errors when I try to split by the tab delimiter
Problem
There's obviously some weird characters in my client's product description that is causing the description to break in the export.
I have narrowed this down to be a range of characters like fullstops, commas and some other things
[attachment=11907:2016-11-30_1417.png]
Solution
1) Change the export code not to break at these characters? I have no idea how to do this, I am not a developer.
2) Write new descriptions in another without any punctuation and assign this to the export.
Any other ideas?
Thanks