Commas being added to export field

  • Resolved amazemedia

    (@amazemedia)


    3 years, 5 months ago

    I have field in WordPress table which uses numbers that are comma separated but All Export is inserting additional commas. For example when I export a field with numbers like:
    12597,13620,1381
    I open exported CSV file I see the field is now
    12,597,136,201,381

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author WP All Import

    (@wpallimport)

    Hey @amazemedia,

    I have field in WordPress table which uses numbers that are comma separated but All Export is inserting additional commas.

    It’s actually Excel that’s displaying the numbers with additional commas. If you open the exported file in a text editor, you should see the original values.

    If you’re needing to view this data in Excel unchanged, you’d need to use a “Custom export field”. With this field type you can add a backtick “`” before the numbers, e.g.: https://d.pr/i/BTKMAi. Then, you’d need to:

    • Copy the values from Excel to a text editor.
    • Do a search and replace to remove the backticks, then copy the correct values.
    • Go into Excel, change the column format to “Text”, then paste in the values from the text editor.
    Thread Starter amazemedia

    (@amazemedia)

    That makes perfect sense, thank you so much for the support and clarification.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Commas being added to export field’ is closed to new replies.