Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to vertically align comma separated values in Notepad++?

Tags:

csv

notepad++

As shown in the picture "Before" below, each column separated by comma is not aligned neatedly. Is there any method to align each column vertically like the display effect in Excel?

The effect I wish is shown in the picture "After". Before After

Thanks to @Martin S , I can align the file like the picture "Method_1". As he has mentioned, some characters still cannot align well. I was wondering if this method could be improved? Method_1

like image 313
T X Avatar asked Jul 18 '17 11:07

T X


People also ask

How do I align data in Notepad?

To make the text align to the right side, right-click inside the Notepad and select Right to left Reading order. To make the text align back to the left side, right-click again and uncheck the Right to left Reading order.

How do I align columns in Notepad?

Column editing is super simple in Notepad++ 🤓 All you have to do is press the Alt key while selecting text. You can use either Alt+Mouse Dragging or Alt+Shift+Arrows. This works perfectly on text that is already aligned.

How do you vertically align text in Notepad++?

Notepad++ has a plugin that does this for you. It's called "Code alignment". It allows you to align text vertically based on characters of your choosing. You can install it via the Plugin Manager for notepad.


1 Answers

You can use the TextFX plugin: Edit > Line Up multiple lines by ...

Note: This doesn't work if the file is read only.

http://tomaslind.net/2016/02/18/how-to-align-columns-in-notepad/

Update 2019: Download link from SourceForge

like image 114
Pedro Reis Avatar answered Sep 20 '22 06:09

Pedro Reis