⚡ Hello Friends ⚡ hope you found this useful! Set the video speed to ⌚ 1.5x/2x speed, if you want to view it in half time! After all, this channel is dedicated to Notepad++ tips and tricks help you code at the speed of thoughts!! Do Subscribe ♥ to my channel (ua-cam.com/channels/bU0jmMgFAfmL1J1BHsEmAA.html) for more videos. 🚩 Let me know what other types of videos you want to see in the future!!
Ah...Thanks for this Information, I wasn't sure what to call this function is. I press [Alt]+[Tab] key switch to other window and switch back, then Notepad++ sometimes locked in this mode. Really frustrated at those moments, It's all good now after watch your video. Beside It looks really convenient now after your explanations!! Thanks!!
Hey Amit, I have a question for you, I don't see this example on you channel. How can you copy a line, take the copied line and paste it on a new line. Then I want to add a backslash / I'd like to do this in a macros, is this possible - TJ
TJ, it is definitely possible. But would you please give a small sample of 3-4 lines so that I can understand your question better. I can make a video out of it as well
Thanks for your answer so fast. I tried but it is not what I need... I need to select a column from the first line to the last line in a file of 2 millions of lines. When I select a column and then press Ctrl+END, I lose the selected column....
If you would like to select these columns, you need to keep the cursor at the first line and then press *CTRL + SHIFT + END* . It would select all these columns. If you have lots of lines, it may take just a fraction of a second to select them, so just wait a bit for it to select all the columns. Let me know if you have trouble selecting these lines. Thanks.
Hi Amit, as like Gabriela, I do have the same question, "how to select 'specific column from beginning to end' of 200000 lines of a file?" CTRL+A or CTRL+SHIFT+END/HOME selects all columns, but the expectation is to select only one column from top to end, so for this, do we have any trick or shortcut?
Mahesh, if you have a very large file with hundreds of thousands of line, the manual selection of first column can be difficult. You have however, use regular expression to get the first character of each line. What would you like to do after you select the first column of every line?
Amit, very good information. This will save a lot of time. However how do you edit the end of a line if the lines are different lengths? For example, I have a file that looks like this: MGM-06530, Assign a value to the attributes of uninitialized objects MGM-06592, None of the ‘WHEN’ clause in CASE statement satisfied and no ‘ELSE’ clause is specified MGM-06531, Using collection methods (except EXISTS) or accessing collection attributes on a uninitialized collections If I needed to add a quotation after the , that would now be easy because they are all in the same column, but adding the closing quote to the end doesn't work for me. Is there a quick solution?
Aaron, yes, you can easily add quotation mark at the end of variable length lines, using regular expression. You can open Search and Replace window (Ctrl + H) Change the search mode to 'Regular Expression'. Then search for (basically means carriage return and means new line) Then in replace box, add '" . (It means that replace with quotation and then ). I have explained this in another video also, let me see if I can find it. Give it a try on a small file with few lines and then once you validate it, you can apply to the entire file. Hope it helps.
what if the text are of different length and the lines of text i want to identify as a column is many like 3000 lines ? Do i have to be scrolling ? Please help
EbenTech, You can still use Column edit mode for a large set of lines (like 3000 lines). You don't need to scroll, you can use PageDown key on your keyboard. So, for example, if you want to add a text on all 3000 lines right at the beginning, you can put your cursor at the top. And press ALT + SHIFT keys together and then press PAGEDOWN key to go down, it can go very fast to all the way at the end of 3000 lines. Now, you can add Text and it will be added to all the lines. Note that it can take a little bit of time for Notepad++ to add these text and it would be non-responsive for a little while. You can also use Regular Expression to do the same. Can you please let me know what exactly are you trying to do? I understand, that above text may be little hard to follow. So, I will create a video tutorial to demonstrate. Thanks.
If I have a lot of lines, for example 2,000,000 lines in a txt.... how can I go to the last line easily.... because using the mouse or the arrows keys is not useful.... is there any trick? any combination of keys to go to the last line with the selection of the column? thanks.
Gabriela, you can use CTRL + END key to go to the last line and you can use CTRL + HOME key to go to the first line. You can also check out this video ( ua-cam.com/video/JvmZGN8Z1Ng/v-deo.html ), in which I specifically have shown some tips and tricks when working with very large files (> 1 million lines). Hope it helps. Please feel free to like or subscribe, if you find these tips handy. Thank you.
For example, there are 100 lines in my text file and I want to add a comma end of each line. This is very easy in sublime. How can I do that in notepad++?
Kshitij, column mode is usually on same file. If you want to apply similar kind of editing, you will need to use regular expressions. Can you please give me an example of what are you trying to do, I can suggest some tips and tricks. Thanks.
Hi Amit, thanks for the reply, my query is that suppose I have 500 notepad files, each containing cnc code written in it.one common trend in each cnc code is that, ever y 4th line item contains information about the quantity, let's say this quantity as 12.similarly other cnc code contains quantity 14 in the same line item no 4.so what I want that all the files with line item no 4 be replaced with quantity 1.
@@howthingswork5763 It would be great, if you paste sort of sample codes (few lines) from 2-3 files. (simplified). Sorry, it would be better so that I can offer some help. Thanks.
You can either use the column edit mode as described in this video. Or you can use Search and Replace feature to edit all lines with single click. Here are two examples, (ua-cam.com/video/8aH4QFnbSY8/v-deo.html), (ua-cam.com/video/fBonIJ61zto/v-deo.html). Hope it helps.
Only disadvatnage I see is that with just what you demoed in this video it's difficult to select a column that has 4000 cells. How do you select the whole column without needing to select cell by cell and one by one?
Se Se, I understand what you are saying. In fact there is a user (EbenTech Studio) who asked for the same thing in the comments below. Here is an excerpt of my response to his question. Hope it will help with your question as well. "You can still use Column edit mode for a large set of lines (like 3000 lines). You don't need to scroll, you can use PageDown key on your keyboard. So, for example, if you want to add a text on all 3000 lines right at the beginning, you can put your cursor at the top. And press ALT + SHIFT keys together and then press PAGEDOWN key to go down, it can go very fast to all the way at the end of 3000 lines. Now, you can add Text and it will be added to all the lines. Note that it can take a little bit of time for Notepad++ to add these text and it would be non-responsive for a little while. There are other ways to achieve this as well. You can use Regular Expression to do the same. Or you can create a notepad++ macro (ua-cam.com/video/jqxNbeEBK8Q/v-deo.html). Thanks.
@@AmitChristian with VSC, when in column mode, I can move around using the arrow keys and will still be in column mode. I can't do that with notepad++; it immediately stops column mode.
⚡ Hello Friends ⚡ hope you found this useful! Set the video speed to ⌚ 1.5x/2x speed, if you want to view it in half time! After all, this channel is dedicated to Notepad++ tips and tricks help you code at the speed of thoughts!!
Do Subscribe ♥ to my channel (ua-cam.com/channels/bU0jmMgFAfmL1J1BHsEmAA.html) for more videos. 🚩 Let me know what other types of videos you want to see in the future!!
Ah...Thanks for this Information, I wasn't sure what to call this function is.
I press [Alt]+[Tab] key switch to other window and switch back, then Notepad++ sometimes locked in this mode.
Really frustrated at those moments, It's all good now after watch your video.
Beside It looks really convenient now after your explanations!! Thanks!!
Glad to help. Thanks for your comment.
dude in the 1st minute you saved me a good 1hr thanks!! :)
Sean, with this one line comment you made my day. Glad that it was helpful and time saving.
I need for the columns to be spaced horizontally across the page. This is easy to do in WordPad- can it be done here?
Not completely sure. But will look, if this can be done in npp. Thanks.
Hey Amit, I have a question for you, I don't see this example on you channel. How can you copy a line, take the copied line and paste it on a new line. Then I want to add a backslash / I'd like to do this in a macros, is this possible - TJ
TJ, it is definitely possible. But would you please give a small sample of 3-4 lines so that I can understand your question better. I can make a video out of it as well
hello Amit , i have like this i want to combine them in one line
wish your help how can i do it by notepad++ automatic
I have posted a video, that may help you. Thanks.
ua-cam.com/video/YlZ52wo8ztw/v-deo.html
Thanks for your answer so fast. I tried but it is not what I need... I need to select a column from the first line to the last line in a file of 2 millions of lines. When I select a column and then press Ctrl+END, I lose the selected column....
If you would like to select these columns, you need to keep the cursor at the first line and then press *CTRL + SHIFT + END* . It would select all these columns. If you have lots of lines, it may take just a fraction of a second to select them, so just wait a bit for it to select all the columns.
Let me know if you have trouble selecting these lines. Thanks.
Hi Amit, as like Gabriela, I do have the same question, "how to select 'specific column from beginning to end' of 200000 lines of a file?" CTRL+A or CTRL+SHIFT+END/HOME selects all columns, but the expectation is to select only one column from top to end, so for this, do we have any trick or shortcut?
Mahesh, if you have a very large file with hundreds of thousands of line, the manual selection of first column can be difficult. You have however, use regular expression to get the first character of each line. What would you like to do after you select the first column of every line?
@@AmitChristian to delete a character from the first column of every line
Thank you, Really helpfull!
Omar, glad to help. Please like to video, if you can. thank you.
Im not sure if it is my keyboard-- but the alt key + arrows just resizes the window. very strange
Hmmm. Not sure. There may be some key remapping going on.
Amit, very good information. This will save a lot of time. However how do you edit the end of a line if the lines are different lengths? For example, I have a file that looks like this:
MGM-06530, Assign a value to the attributes of uninitialized objects
MGM-06592, None of the ‘WHEN’ clause in CASE statement satisfied and no ‘ELSE’ clause is specified
MGM-06531, Using collection methods (except EXISTS) or accessing collection attributes on a uninitialized collections
If I needed to add a quotation after the , that would now be easy because they are all in the same column, but adding the closing quote to the end doesn't work for me. Is there a quick solution?
Aaron, yes, you can easily add quotation mark at the end of variable length lines, using regular expression.
You can open Search and Replace window (Ctrl + H)
Change the search mode to 'Regular Expression'.
Then search for
(basically
means carriage return and
means new line)
Then in replace box, add '"
. (It means that replace with quotation and then
).
I have explained this in another video also, let me see if I can find it.
Give it a try on a small file with few lines and then once you validate it, you can apply to the entire file.
Hope it helps.
🔥🔥🔥
Thanks
Thanks, dude.
Md Abdullah Al Mamun, you are very welcome. Please like the video if you can.
what if the text are of different length and the lines of text i want to identify as a column is many like 3000 lines ? Do i have to be scrolling ? Please help
EbenTech, You can still use Column edit mode for a large set of lines (like 3000 lines). You don't need to scroll, you can use PageDown key on your keyboard. So, for example, if you want to add a text on all 3000 lines right at the beginning, you can put your cursor at the top. And press ALT + SHIFT keys together and then press PAGEDOWN key to go down, it can go very fast to all the way at the end of 3000 lines. Now, you can add Text and it will be added to all the lines. Note that it can take a little bit of time for Notepad++ to add these text and it would be non-responsive for a little while.
You can also use Regular Expression to do the same. Can you please let me know what exactly are you trying to do?
I understand, that above text may be little hard to follow. So, I will create a video tutorial to demonstrate. Thanks.
Any idea how to do this on mac? any help is appreciated
Do you have Notepad++ installed on mac, right? Did you try to select using ALT + Left Mouse Button to select a column edit mode?
thanks it's helpful
CM, you are very welcome. Please like the video if you can.
If I have a lot of lines, for example 2,000,000 lines in a txt.... how can I go to the last line easily.... because using the mouse or the arrows keys is not useful.... is there any trick? any combination of keys to go to the last line with the selection of the column? thanks.
Gabriela, you can use CTRL + END key to go to the last line and you can use CTRL + HOME key to go to the first line.
You can also check out this video ( ua-cam.com/video/JvmZGN8Z1Ng/v-deo.html ), in which I specifically have shown some tips and tricks when working with very large files (> 1 million lines). Hope it helps. Please feel free to like or subscribe, if you find these tips handy. Thank you.
How can we achieve this in mac OS
You can install Notepad++ on MacOS. Checkout my channel and view the video about how to install Notepad++ on Mac. Thanks.
For example, there are 100 lines in my text file and I want to add a comma end of each line. This is very easy in sublime. How can I do that in notepad++?
Naimul, you can also do that very easily in Notepad++, you just simply use Extended mode (
,
) for search and replace it with comma.
Search for:
replace with: ,
Thanks.
@@AmitChristian by using control replace and replacing $ with regular expression checked on it can be done.
How can we do the same thing for multiple opened notepad files
Kshitij, column mode is usually on same file. If you want to apply similar kind of editing, you will need to use regular expressions. Can you please give me an example of what are you trying to do, I can suggest some tips and tricks. Thanks.
Hi Amit, thanks for the reply, my query is that suppose I have 500 notepad files, each containing cnc code written in it.one common trend in each cnc code is that, ever y 4th line item contains information about the quantity, let's say this quantity as 12.similarly other cnc code contains quantity 14 in the same line item no 4.so what I want that all the files with line item no 4 be replaced with quantity 1.
@@howthingswork5763 It would be great, if you paste sort of sample codes (few lines) from 2-3 files. (simplified). Sorry, it would be better so that I can offer some help. Thanks.
How i can edit all lines in one click? i have a goce with a lot of same command?
You can either use the column edit mode as described in this video. Or you can use Search and Replace feature to edit all lines with single click. Here are two examples, (ua-cam.com/video/8aH4QFnbSY8/v-deo.html), (ua-cam.com/video/fBonIJ61zto/v-deo.html). Hope it helps.
@@AmitChristian Thanks a lot! now i know how to do it! it work!!!
Only disadvatnage I see is that with just what you demoed in this video it's difficult to select a column that has 4000 cells. How do you select the whole column without needing to select cell by cell and one by one?
Se Se, I understand what you are saying. In fact there is a user (EbenTech Studio) who asked for the same thing in the comments below. Here is an excerpt of my response to his question. Hope it will help with your question as well.
"You can still use Column edit mode for a large set of lines (like 3000 lines). You don't need to scroll, you can use PageDown key on your keyboard. So, for example, if you want to add a text on all 3000 lines right at the beginning, you can put your cursor at the top. And press ALT + SHIFT keys together and then press PAGEDOWN key to go down, it can go very fast to all the way at the end of 3000 lines. Now, you can add Text and it will be added to all the lines. Note that it can take a little bit of time for Notepad++ to add these text and it would be non-responsive for a little while.
There are other ways to achieve this as well. You can use Regular Expression to do the same. Or you can create a notepad++ macro (ua-cam.com/video/jqxNbeEBK8Q/v-deo.html).
Thanks.
unlike VSC, we can't use the arrow keys to move location...
Can you please explain a bit more, what feature in VSCode, are you mentioning?
@@AmitChristian with VSC, when in column mode, I can move around using the arrow keys and will still be in column mode. I can't do that with notepad++; it immediately stops column mode.