CSV File: View, Add Column Colors and Sort Data using Notepad++

Подписаться 6 тыс.

Просмотров 13 тыс.

50% 1

This tutorial will show you how to view CSV File (Comma Separated Values file), add column colors and also sort data by any columns using Notepad++. We will use Notepad++ TextFX plugin and CSV Lint Plugin.
CSV files can also be opened with Microsoft Excel, but it often forces users to save files as .xlsx files. CSV Data file does not need Excel to open, it can be opened in any text editor. It is easy to manipulate CSV files, sorting the columns using Notepad++.
[2022-11-08] Note from Bas, the creator of this Plugin:
The latest update of the CSV Lint plugin v0.4.6.2 now has a Sort feature. Meaning you can sort CSV files on a selected column. Note that integer, decimal and datetime values won't be sorted alphabetically, but they are sorted correctly according to their integer, decimal or datetime values.
🚩 TIMESTAMPS 🚩
00:00 Introduction
00:58 What is CSV File?
02:32 Add Syntax highlighting colors and column detection using CSV Lint plugin
05:22 Sort Columns in CSV file using Notepad++ TextFX plugin
07:00 Example 1: Sort CSV by Text (Last Name)
09:52 Example 2: Sort CSV by numbers (Price, Mileage)
#CSVFile #CSVFiles #CSVSortColumns
---
🚩 Checkout My other playlists 🚩
Notepad++ HTML tutorials, • NOTEPAD++ HTML TUTORIA...
Notepad++ tips and tricks, • Notepad++ TUTORIALS FO...
Notepad++ Themes, Fonts, Look and Feel, • Notepad++ Themes, Dark...
Notepad++ One Minute Challenge, • Notepad++ Tips & Tricks
---
🚩 please LIKE or SUBSCRIBE.
🚩 Please COMMENT If You Like To See Any Video On Specific Topic
Music Credits:
------------------------------
Track: Our Leaves in the Breeze - Artificial.Music [Audio Library Release]
Music provided by Audio Library Plus
Watch: • Our Leaves in the Bree...
Free Download / Stream: alplus.io/our-leaves-breeze
------------------------------

Хобби

Опубликовано:

1 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 40

@im2ez4u2nv 2 года назад

super useful video... thank you Amit!

@AmitChristian 2 года назад

Most welcome! Mr. Smith.

@unitedstandardpos4571 Месяц назад

Hi Amit How do you increase column width in CSVLint Thanks great videos!

@virenchaudhari5212 Год назад

Excellent video sir

@AmitChristian Год назад

Thanks. Glad to know that it was helpful.

@ingenieriapaula8711 2 месяца назад

Hola estuve intentado realizar los mismos pasos pero en la version que tengo no aparece el textFX Edit, existe alguna manera de hacer la alineacion sin usarlo?

@andreyzhuchkov1882 Год назад

Hello, thank you for the content, been wondering where did you prepare such a neat leaf directory of the topics covered in the vid? Very neat and good visual support for what you are relating.

@AmitChristian Год назад

Andrey, I am using a mind mapping tool called Freeplane, it is a free open source software. You can give it a try.

@stargazzer8703 Год назад

many thanks sire

@AmitChristian Год назад

You’re welcome. Glad to know it was helpful

@jaimenash9490 2 года назад

Hi Amit! Thank you for producing such useful videos. Would you mind sharing which mind mapping program you are using in this video?

@AmitChristian 2 года назад

Jaime, thank you. I use FreePlane mind mapping tool, it is free, open source and have a pretty dedicated community. It has a slight learning curve, but overall, I am pretty happy with it. Please like&share the videos. Thank you.

@dezertson1165 Год назад

CSV Lint is not highlighting the columns. It says the data validates and properly recognizes the columns, but no highlighting.

@im2ez4u2nv Год назад

Hi Amit... do you have a recommendation for a TextFX replacement, apparently its not supported anymore and one can't install in the 64 bit version. I found the delimiter "line up" function super helpful. Any advice would be most helpful. thank you sir!

@AmitChristian Год назад

Believe it or not, I just had posted a video few weeks ago about TextFX plugin. Currently it is only available in 32bit application. There is a sort of alpha version of 64bit textFx plugin, but it remains untested. (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYwAEchP9D4.html). So, far I have not found a suitable alternative for TextFX, if I do, I will let you know. Thank you for your comment.

@larock0wns 9 месяцев назад

A better CSV plugin is CSVQuery. It's 64 bit compatible. It doesn't do the colors, but it does a little data window. You can sort, you can filter via little select statements, you can show row numbers - so if you do like where lastname='smith' it will show you just those rows, you can create new csv based on your filter/sort etc

@AmitChristian 9 месяцев назад

@larock0wns thanks for the recommendation. I will check it out. I haven’t used a CSV plugin in a while, so haven’t kept up with it. Thanks.

@samuelunbelievable Год назад

Hi Amit, first of all thank you for your content! I wanted to ask you if you knew how to install TextFX, it seems modern versions of NotePad++ won't support it anymore. Thanks in advance.

@AmitChristian Год назад

Hi Samuel, I will check that out. I know textFX is an awesome plug-in.

@AmitChristian 2 года назад

⚡ Hello Friends ⚡ hope you found this useful! Do Subscribe ♥ to my channel (ru-vid.com/show-UCbU0jmMgFAfmL1J1BHsEmAA) for more videos. 🚩 Let me know what other types of videos you want to see in the future!!

@rbdenham 2 года назад

Hi Amit! Nice video. I have a question. If I have a large file with 10k records, how do I select the column? For instance, using the Alt and mouse down the column would take forever, so how would you do it?

@AmitChristian 2 года назад

rbdenham, if you have a large file with thousands of records, you can technically use column edit mode (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DxQ30PxtEKc.html ). I just tried it. All you have to do is to select Shift + ALT keys and select the few lines (vertical selection) and then use the mouse to scroll to the end of the file (probably thousand of lines below), and then select that column again. Notepad++ would select the entire column. Now you can add a text there. The only caveat is that Notepad++ will become unresponsive for a bit, but once it finishes the task of adding text to all those thousands of lines, it will be responsive again. However, it is better to use Regular expression for such task, you can search and replace with regular expression mode enabled. I have some videos about using Regex ( ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MpEdP8-ZNRY.html ). You can also post a small sample of your text here and tell me what you would like to do, and I can help you get the regular expression for it. Thanks. All the best.

@rbdenham 2 года назад

@@AmitChristian You are the man! I did what you told me with the shortcut keys and the vertical slider bar quickly to the bottom and that worked. Honestly, this started with me trying to get the Regex to work. It was my first time using it, so i would need help from you if possible. I will reach out to you another time to get you some sample data and hopefully you will have some time to do this simple Regex LOL. I started working with it last week, but need to get my feet wet :-) . I will check out your tutorial. Thank you buddy!

@AmitChristian 2 года назад

Sure. Glad to help. Let me know and we can try some regex. Thanks.

@rbdenham 2 года назад

@@AmitChristian How can I send you a private message and show you what I am trying to do? I have made headway, but now my fixed columns are off with the replacement because each email address is different lengths. The email address field is a fixed column of 65 characters, and the replacement one throws off the next field in the fixed columns because of the varying size of the original email address. This is driving me nuts LOL

@AmitChristian 2 года назад

@@rbdenham If you go to my channel page, there is an option for email address, plz send me your detailed info through that email and I will try to help you as much as I can. Thanks.

@HawkFest 22 дня назад

Thank you. Something unfortunate for me: 1- I've installed the plugin, then exit the program and reload just to make sure; 2- Loading a Google contact CSV file shows the colors, however the columns are not aligned: empty fields are squeezed, and others are as large as their data for each record (line). It's a coma delimited file. EDIT: same thing with an Outlook CSV file... I'll try to see with the creator (if it's possible in some manner) EDIT2: I solved the problem: in the CSVLint window, I had to click the "Reformat" button, check "Align vertically" and then "Ok". All is good now! 🙂

11 дней назад

You're the guy! Thanks! Any chance to format um columns automatically when open an CSV file?

@HawkFest 11 дней назад

I didn't see the option in the settings dialog, sorry. Also, on an Outlook csv file, it seems to impose a hidden column limit which cannot be changed: clicking on "Validate data" will throw a _too many columns error"_ on every line/record.". Same thing for a data fields having a string of characters within quotes: if it's too long it will remove the last quotation mark, and throw a validation error when clicking "Validate data"..

11 дней назад

Thanks for the quick answer Mate! You already helped a lot!

@StephenBrincat 10 месяцев назад

Manged to download Text FX 64 but upon editing lineup multiple lines I'm getting a pop up saying out of memory 😏

@robertminardi849 Год назад

Where are you getting TextFx, it doesn't exist in my latest version of Notepadd++. I just need to align columns using commas

@AmitChristian Год назад

I will make a video of TextFX soon. Hopefully that will help. Thanks.

@NealHartsChannel Год назад

My columns don't all line up. What do you do to get them in a straight column? I have windows 11 64bit and there is no TextFX for Notepad++ 64bit.

@AmitChristian Год назад

Neal, most likely, there would be an issue with CSV file. Can you please add a few lines of csv file sample here?

@NealHartsChannel Год назад

@@AmitChristian Period,Orders,Sales Items,Items,Sales Total,Revenue,Profit,Invoiced,Paid,Refunded,Sales Tax,Tax,Sales Shipping,Shipping,Sales Discount,Discount,Canceled 2022,152,201,201,"$3,789.45 ","$2,772.20 ","$2,772.20 ","$3,789.45 ","$3,789.45 ",$71.59 ,$66.45 ,$66.45 ,$879.21 ,$879.21 ,$25.76 ,($21.50),$0.00 Total,152,201,201,"$3,789.45 ","$2,772.20 ","$2,772.20 ","$3,789.45 ","$3,789.45 ",$71.59 ,$66.45 ,$66.45 ,$879.21 ,$879.21 ,$25.76 ,($21.50),$0.00

@AmitChristian Год назад

@@NealHartsChannel I saved the data you sent as a CSV file. And I was able to get the colors for different columns, but the columns are not aligning for me either. I may have to take a look at this. BTW, you may not be seeing TextFX Plugin, because TextFX plugin in only available for 32 version of Notepad++ and you may have Notepad++ 64 bit application. Take a look at this video for more details. (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYwAEchP9D4.html). Thanks.

@NealHartsChannel Год назад

@@AmitChristian yes I believe that's what my problem is also. Unfortunately there doesn't seem to be a suitable replacement TextFX for Notepad++ 64bit. Thank you for helping!