Export to CSV without line breaks

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #105651
    Zavera Ana Maria
    Participant

    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!

    • This topic was modified 1 year, 6 months ago by Omar Dabbas.
    #105652
    Tom Anbinder
    Moderator
    Plugin Support

    Hi,

    As far as I know, wrapping output in quotes should solve the issue, so please try something like:

    [alg_product_sku];[alg_product_title];[alg_product_url];[alg_product_price];"[alg_product_description]";

    Please let me know if that helped.

    #105653
    Tom Anbinder
    Moderator
    Plugin 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="'"]";
    #105654
    Zavera Ana Maria
    Participant

    Hello, I solved the problem with the following shortcode –
    [alg_product_description find=”
    ” replace=””]

    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!

    #105655
    Zavera Ana Maria
    Participant

    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 🙂

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.