Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#1005 \n converted to /n on copy/past multiple rows

open
Rob Manning
Unknown (89)
5
2012-12-29
2011-11-03
Anonymous
No

Copying multiple rows (Select All -> Copy or Ctrl-A Ctrl-C) where the data in one of the columns has line breaks (\n). When pasted into notepad or excel, line breaks are replaced with /n (forward slash)

works fine when copying/pasting a single cell with line breaks

Very inconvenient :(

Discussion


  • Anonymous
    2011-11-03

    correction: line breaks are replaced with /n even in the result grid. double click to open the value popup and they disappear

    select 'a' || char(10) || 'b' || char(10) || 'c'
    result: 'a/nb/nc'

    using hsqldb

     
    Last edit: Anonymous 8 hours ago
  • Claus
    Claus
    2011-11-23

    I use DB2 and it doesn't matter whether I select one or multiple rows.

    Here the exact result with Line Feed (Unix-Windows-Difference?)

    Test:
    SELECT 'First Line' || x'0D0A' || 'second Line' FROM sysibm.sysdummy1;

    x'0D0A'
    => Line Break and /n
    x'0A'
    => no Line Break and /n
    x'0D'
    => Line Break and no /n but instead of all other Versions it won't be marked with "greenblue" color in SquirreL