Carriage Returns

  • Resolved provdes

    (@provdes)


    11 years, 6 months ago

    I am trying to import a large csv which has one field that will be going into a text area on the site. The field contains postal addresses as one block, but 90% of these addresses have carriage returns (line breaks) within them. Eg:

    House Name
    Street Name
    City
    County
    Post Code

    When importing using your plugin any rows that have addresses that have been written like this are not imported.

    Is there a fix for this, other than editing the line breaks out of the entire csv?

    https://ww.wp.xz.cn/plugins/import-users-from-csv-with-meta/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Javier Carazo

    (@carazo)

    11 years, 6 months ago

    provdes,

    Good morning, this is a bug of the plugin. The plugin is not prepared to read \n or \r or \n\r inside fields because the parsr firstly breaks the file in lines.

    In CODECTION we have no time to fix it (it would need a complete code change), the only way is that some support this develop.

    If you want or any other tell me.

    Thread Starter provdes

    (@provdes)

    11 years, 6 months ago

    Awww man – that is such a shame!!

    I have so many users to import and so many line breaks to remove.

    For anyone else with the same issue, the only work around we have is to manipulate the csv in Excel and remove the line breaks using either formula or macro.

    Details on how were in this very useful page:

    https://www.ablebits.com/office-addins-blog/2013/12/03/remove-carriage-returns-excel/

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Carriage Returns’ is closed to new replies.