⚡ Hello Friends ⚡ hope you found this useful! Do Subscribe ♥ to my channel (ruclips.net/channel/UCbU0jmMgFAfmL1J1BHsEmAA) for more videos. 🚩 Let me know what other types of videos you want to see in the future!!
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!
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. (ruclips.net/video/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.
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
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.
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?
@@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. (ruclips.net/video/lYwAEchP9D4/видео.html). Thanks.
@@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!
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! 🙂
8 месяцев назад+1
You're the guy! Thanks! Any chance to format um columns automatically when open an CSV file?
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"..
8 месяцев назад+1
Thanks for the quick answer Mate! You already helped a lot!
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.
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?
rbdenham, if you have a large file with thousands of records, you can technically use column edit mode (ruclips.net/video/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 ( ruclips.net/video/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.
@@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 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
@@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.
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.
⚡ Hello Friends ⚡ hope you found this useful! Do Subscribe ♥ to my channel (ruclips.net/channel/UCbU0jmMgFAfmL1J1BHsEmAA) for more videos. 🚩 Let me know what other types of videos you want to see in the future!!
Excellent video sir
Thanks. Glad to know that it was helpful.
Hi Amit How do you increase column width in CSVLint Thanks great videos!
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!
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. (ruclips.net/video/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.
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
@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.
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.
Hi Samuel, I will check that out. I know textFX is an awesome plug-in.
super useful video... thank you Amit!
Most welcome! Mr. Smith.
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?
Where are you getting TextFx, it doesn't exist in my latest version of Notepadd++. I just need to align columns using commas
I will make a video of TextFX soon. Hopefully that will help. Thanks.
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.
Neal, most likely, there would be an issue with CSV file. Can you please add a few lines of csv file sample here?
@@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
@@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. (ruclips.net/video/lYwAEchP9D4/видео.html). Thanks.
@@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!
CSV Lint is not highlighting the columns. It says the data validates and properly recognizes the columns, but no highlighting.
many thanks sire
You’re welcome. Glad to know it was helpful
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! 🙂
You're the guy! Thanks! Any chance to format um columns automatically when open an CSV file?
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"..
Thanks for the quick answer Mate! You already helped a lot!
Hi Amit! Thank you for producing such useful videos. Would you mind sharing which mind mapping program you are using in this video?
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.
Manged to download Text FX 64 but upon editing lineup multiple lines I'm getting a pop up saying out of memory 😏
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?
rbdenham, if you have a large file with thousands of records, you can technically use column edit mode (ruclips.net/video/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 ( ruclips.net/video/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.
@@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!
Sure. Glad to help. Let me know and we can try some regex. Thanks.
@@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
@@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.
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.
Andrey, I am using a mind mapping tool called Freeplane, it is a free open source software. You can give it a try.