Locked Need help to change multiple rows to columns in Notepad++ or any Similar Software

akkubhai · Aug 7, 2022

Hello,
I want to change the multiple rows to columns in Notepad++ for example below as I am having similar multiple rows in one single text like more than 100 similar to the below format.

The example is below and it contains space in between each row

to

Leadertech Cons, Parkgate Boulevard
s.on("dom-start" ,function(t)
Cave CrossRing Rd.Byland

and need to add HTML coding as well.

Example:

<HTML>
<body>
Leadertech Cons, Parkgate Boulevard
s.on("dom-start" ,function(t)
Cave CrossRing Rd.Byland
</body>
</html>

All this need to be done in Notepad++ or any similar software.

Please need help. Thank you.

mobi0001 · Aug 7, 2022

Someone expert will surely help, but in the meantime, have you tried stackoverflow and asked there? You may get response with proper coding as well (hopefully).
BTW, interesting point.. 👍

juanamm · Aug 7, 2022

@akkubhai,

You need to choose right tool for the job. Use Excel to help you with your text file. Inside the Excel:

Use Text import wizard (menu Data > From Text) to import values into cells.
Select imported cells (as rectangular selection) and use Copy.
Select where to paste the result.
Use Paste Special with Transpose option to flip rows and columns (this is what you requested).
Paste the result back to text file (Notepad++ or whatever editor you use).

Another way is using regular expressions in Notepadd++, if you are in the world of programming I think you know how to use them, otherwise you will have to learn their use (I send you an example in PM).

Passing the example that you have put and the result that you want to obtain:

TO

Code:

Leadertech Cons, Parkgate Boulevard
s.on("dom-start" ,function(t)
Cave CrossRing Rd.Byland

As this uses regular expressions your search mode must be “regular expression”.
Use the Replace function and copy the below text into each of the fields.

Find What:\s{3}

Note: If the number of spaces is not 3, substitute the number in the curly brackets with the correct number of spaces.
If instead of blank spaces you have used tabs use: \t+

Replace With:\r

If you have doubts I share more info by PM.
Remember that this is an OS forum, you should ask these types of questions in a specialized programming forum such as superuser (source of the Excel solution), stack overflow, etc.

akkubhai said:
and need to add HTML coding as well....

You have to learn the HTML tags by heart and copy them by hand (it doesn't take long that task).
If you don't want to write them, copy this HTML template and paste it into your editor, then complete with your code.

Code:

<!DOCTYPE html>
<html lang=”en”>
<head>
    <meta charset=”UTF-8″ />
    <title>Document</title>
</head>
<body> </body>
</html>

If you want to find shortcuts when writing commands so as not to make mistakes in the syntax, you can use Visual Studio Code with the Emmet plugin.

You can also use other editors like Sublime Text or Komodo Edit instead of Notepad++...

akkubhai · Aug 8, 2022

@juanamm Thank you for your help, could you please check your PM. I have send you an Message, as I need to perform on all the lines not on the single line.

Uncle Mac · Aug 8, 2022

@juanamm very nicely explained...you are admitted to the club

...thank you

juanamm · Aug 9, 2022

akkubhai said:
@juanamm Thank you for your help, could you please check your PM. I have send you an Message, as I need to perform on all the lines not on the single line.

I have already answered all your doubts by PM.

akkubhai · Aug 9, 2022

@juanamm Thank you so much. You can close the thread.

Locked Need help to change multiple rows to columns in Notepad++ or any Similar Software

akkubhai

mobi0001

The Power Is Yours!!!

juanamm

Uploader

akkubhai

Uncle Mac

juanamm

Uploader

akkubhai