# 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?

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