Exported CSV file contain unwanted character

  • Resolved Madhuben Prajapati

    (@maheshprajapati35)


    3 years, 12 months ago

    While We export CSV file of all products,
    In column named post_excerpt, it contain some unwanted words like
    “/n”, “>”, “\”
    We want to remove such chracter in our exported file,
    How can we filter this issue?????

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author WebToffee

    (@webtoffee)

    3 years, 12 months ago

    Hi @maheshprajapati35,

    Could you please share a sample short description content with which you are having the issue so that we can check it.

    Thread Starter Madhuben Prajapati

    (@maheshprajapati35)

    3 years, 12 months ago

    The uploaded short description of product is
    ”
    > No Extra Charges For Delivery
    > Delivery Within 3-4 Working Days
    ”

    and in Exported CSV file we get the output is
    ”
    &g t; No Extra Charges For Delivery\n&g t; Delivery Within 3-4 Working Days
    “

    • This reply was modified 3 years, 12 months ago by Madhuben Prajapati. Reason: special character not showing as i typed
    Thread Starter Madhuben Prajapati

    (@maheshprajapati35)

    3 years, 12 months ago

    and if i again import the same file which was exported,
    then all short description was thrashed with special characters…

    Thread Starter Madhuben Prajapati

    (@maheshprajapati35)

    3 years, 11 months ago

    any suggestion to convert this variables???

    Thread Starter Madhuben Prajapati

    (@maheshprajapati35)

    3 years, 11 months ago

    @webtoffee

    Plugin Author WebToffee

    (@webtoffee)

    3 years, 11 months ago

    Hi @maheshprajapati35,

    The data in the exported CSV file is different because in the database the symbol “>” is stored as &g t;. Our plugin just exports the data as it is in the database to the CSV file.

    We tried using your short description content and was able to import back the exported CSV file without having any issues with the description data. Could you please share with us your importing CSV file via support so that we can check it.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Exported CSV file contain unwanted character’ is closed to new replies.