• Login
Community
  • Login

Hi I stuck with row and columns

Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
2 Posts 2 Posters 1.6k Views
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N
    Notepadplusplusisthebest
    last edited by Dec 12, 2017, 3:43 PM

    Hi I know how to from column

    1;
    2;
    3;
    4;
    5;
    6;

    Get row

    1;2;3;4;5;6

    But how to get from row 1;2;3;4;5;6;7;8;9
    to column with an exact number of characters. I need this for words, but made an example with numbers.
    1;2;3
    4;5;6
    7;8;9

    Can someone help me with this?
    Thanks in advance

    1 Reply Last reply Reply Quote 0
    • G
      guy038
      last edited by Dec 12, 2017, 7:27 PM

      Hello, @notepadplusplusisthebest,

      Very easily, indeed !

      Open the Replace dialog ( Ctrl + H )

      SEARCH .{6}

      REPLACE $0\r\n

      OPTIONS Regular expression ticked and . matches newline unticked

      ACTION : Click on the Replace All button or several ones on the Replace button

      Remark : If you’re using Unix files, the REPLACE regex should be $0\n


      An other example . Suppose the line, below :

      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9
      

      then the regex S/R :

      SEARCH .{5}

      REPLACE $0\r\n

      Would change that line into :

      ----+
      ----1
      ----+
      ----2
      ----+
      ----3
      ----+
      ----4
      ----+
      ----5
      ----+
      ----6
      ----+
      ----7
      ----+
      ----8
      ----+
      ----9
      

      Best Regards

      guy038

      1 Reply Last reply Reply Quote 0
      1 out of 2
      • First post
        1/2
        Last post
      The Community of users of the Notepad++ text editor.
      Powered by NodeBB | Contributors