Home › Forums › Product XML Feeds for WooCommerce › Export to CSV without line breaks
- Support forum for the Product XML Feeds for WooCommerce.
- This topic has 0 replies, 2 voices, and was last updated 3 years, 8 months ago by Zavera Ana Maria.
September 26, 2019 at 7:39 pm #105651
Hello, I’m trying to generate a CSV file using this plugin, but I’m having trouble with line breaks. How do you suggest I should proceed? More precisely, in product description, there are line breaks. Every product should be on 1 line in order for the CSV file to be valid.
Thank you for your support!
September 26, 2019 at 11:26 pm #105652Tom AnbinderModeratorPlugin Support
- This topic was modified 2 weeks, 4 days ago by Omar Dabbas.
As far as I know, wrapping output in quotes should solve the issue, so please try something like:
Please let me know if that helped.September 26, 2019 at 11:40 pm #105653Tom AnbinderModeratorPlugin Support
P.S. You may also want to replace the original double quotes in your product description with single quotes, e.g.:
[alg_product_sku];[alg_product_title];[alg_product_url];[alg_product_price];"[alg_product_description find='"' replace="'"]";September 27, 2019 at 12:08 am #105654
Hello, I solved the problem with the following shortcode –
I have inserted the newline as a character to be replaced with a . I’m having some issues with some special characters now – ă, â, î, ș, ț – they are displayed weird
Are those supported?
Example – lână is displayed lÃ¢nÄƒ
How should I proceed? Thank you!September 27, 2019 at 12:18 am #105655
Coming back with an update – it seems that opening the CSV file in a text editor (Sublime Text, for example) renders the characters just fine. If I try to import the CSV into Excel, the characters get garbled like stated before. I believe it is not related to the plugin, but to Excel. My mistake 🙂
- You must be logged in to reply to this topic.