How do I add line breaks in attributes in csv file?

  • Resolved mommaroodle

    (@mommaroodle)


    5 months, 1 week ago

    So above is how is one of my attributes when added manually – after csv export and re-import – it looks like this (see below) – so what myself and many others before me are trying to find out is how to add a line break in the csv file so that it doesnt reflect as it does in the image below.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi there,

    Thanks for reaching out.

    how to add a line break in the csv file

    I understand you’re having trouble with line breaks when exporting and re-importing your CSV files. As far I understand, CSV files do not support line breaks within a cell, as they are designed for plain text data.

    However, there’s a workaround you can try. Instead of using a line break, you can use a unique character or sequence of characters to denote a line break (e.g., ++?). After importing the CSV file, you can then use a script or manual find and replace function to replace these characters with actual line breaks.

    Here’s a sample query to find and replace the ++?character:

    UPDATE wpwoo_postmeta<br>SET<br>meta_value = REPLACE(meta_value,<br>‘++’,<br>‘\r\n’);

    For reference, you can check out this thread here.

    Please ensure that the character or sequence of characters you choose does not occur naturally in your data to avoid confusion.

    I hope this helps!

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi @mommaroodle,

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem!

    If you have further questions, please feel free to open a new topic.

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