Is there a way in Notepad++ to convert a comma-separated file to fixed width columns?
This feature exists in UltraEdit and explained in Working with CSV files, but I am happy with my Notepad++, and I don't want to pay for a copy of UltraEdit.
Is there a way in Notepad++ to convert a comma-separated file to fixed width columns?
This feature exists in UltraEdit and explained in Working with CSV files, but I am happy with my Notepad++, and I don't want to pay for a copy of UltraEdit.
Use the built in TextFX menu.
TextFX -> TextFX Edit -> Line up multiple lines by (,)
I didn't discover this on my own, I found it on sourceforge while trying to figure out this exact question!
In the meantime I have just found a very nice tool for that. It's called CSVed and available here, with many many nice features. If you hate Excel when viewing CSV files like I do, you should give it a try.
For TSV files (tab separated) and newer Notepad++ release (either x86 or x64) the plugin Elastic Tabs is very helpful for this. I have it configured for .tsv files and it works like a charm.
Another plugin that maybe helpful in conjunction is CSV Lint, but didn't had the need for it yet. It features conversion between CSV comma, CSV semicolon and TSV formats.
Yes, it's possible in Notepad: menu Edit -> Replace... -> ReplaceAll ',' by '\t'.