Export or Save as Excel Files with Pipe (or Other) Delimiters Instead of Commas
Nav : Control Panel -->Region and Language -->Additional settings -->List separator -->|
MONDAY, AUGUST 31, 2015
Notepad ++ Tips and Tricks for Technical Developers
Add "," comma to end of lines
Notepad made life is easier for user to add comma at the end of the each row.1) Keep the cursor at the end of the column (See below image)
2) Press SHIFT + ALT + DOWN ARROW KEY till you reach last row or drag till the rows you wish to add comma (See below image)
3) Press "," comma and you see comma is added to end of all rows,
- You can also use this feature for indenting as well. In the above example, you just have to use SPACE or TAB instead of COMMA.
Box Selection:
Box Selection (aka column selection, block selection, or rectangular selection) exists in Notepad++. You need to hold down the Alt key while doing a selection; you can select a block horizontally.
Add Line Numbers or any Text in front of the line or end of the line :
-->Edit > Column Editor > Number to Insert > Set Initial Number and Increase By >OK (ALT+C)
Initial Number : 1 (Starting number)
Increased by : 1 (Number incremental)
Repeat : 2 (Number of lines for repeat the number )
Leading Zero : Adding the 0 before the number like 0001, 0010, 0100
You can add any text also.
Convert the Multiple Rows into Single Row
-->Edit > Blank Operations > Remove Unnecessary Blank and EOL
Press Ctrl+H , Select the 'Extended Search Mode'. Use \r in find what and COMMA ( , ) in replace with textbox. Click Replace All button
Press Ctrl+H , Select the 'Extended Search Mode'. Use COMMA ( , ) in find what and ,\n in replace with textbox. Click Replace All button
--> TextFX > TextFX Tools >Sort lines case sensitive
No comments:
Post a Comment