Hi I stuck with row and columns



  • 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



  • 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


Log in to reply