Notepad ++(PlusPlus) Auto increment line numbering or symbol (bullet) to the text content using Column / Multi-Selection Editor

 Hi folks,

I was searching for automatically adding numbers for the content which is distributed in sequential lines

Sample Input

A

B

C

Multi-line Column Select

• Press and hold Alt keyboard button and drag the mouse cursor from top-bottom (bottom-top) in the same column (say column 1)
• Keyboard Shortcut: Press and hold Shift + Alt and Click DownArrow/UpArrow until the end of the column

Column / Multi-Selection Editor

1. Click Edit Menu
2. Select Column Editor (Alt + C)

Insert Number list

1. Choose "Number to Insert" section
2. Enter the values in "Initial Number", "Increased by" and "Repeat"
3. Check "Leading Zeros", if required

Insert Text

1. Choose "Text to Insert"
2. Insert the desired text/symbol

Format Selection

1. Choose the desired format
2. Default to "Decimal"

Please find the below image for your reference

Sample Output of auto increment number

1A

2B

3C

Sample Output of prefixing hyphen (-) to list

- A

- B

- C

Hopy this blog gives to explore more of Notepad++ editor. Happy hacking.

Please send your feedback and response to psrdotcom@gmail.com

Change currency (Rupees and Euros) to English text in Microsoft Excel

Hi Friends,

Today I'll discussing about converting currency (Rupees and Euros) to textual representation which I have found by googling and updated to cover 2 currencies.

Source

The VBA Macro code is available on my public GIST
ConvertCurrencyToEnglish.txt

Usage

• Add this in your excel module using developer options
• Two functions
• ConvertRupeesToEnglish - Which converts numeric data to rupees with pre-pending "Rupees " and appending " Only"
• ConvertEurosToEnglish - Which converts numeric data to rupees with pre-pending "Euros " and appending " Only"
• Note: If number has precisioin, it will add "Paise" and "Cent" to respective currency.

Please send your review and feedback to psrdotcom@gmail.com

Add (append or prepend) text along with excel functions/formula in a single cell

Hi friends,

Today I have come across a situation where i want to have the cell to descriptive and to have summation of some cells. I have got information on how to do it. Please find below

Input Data:

3

4

2

I want a cell to be on top those with description and summation value

Expected output data:

Sum = 9

3

4

2

To get the output, I have written the following function

Syntax:
="Text"& function

Example:
="Sum = "& SUM(A2:A4)

We can append and prepend the text to excel function to combine text and numbers as well.

Please send your comments and feedback to psrdotcom@gmail.com

Text Formatting in *NIX to run Script files of Different Platforms

Hello all,

While writing shell scripting in Ubuntu, Windows and deploying it in *NIX based machine, we found some issue. That the file running perfectly on the Ubuntu (Linux), Windows machine. The same script was displaying errors like

'\r': command not found

^M: command not found

There was a formatting issue. You need to run the following command to resolve it.

DOS2UNIX

Installation:
sudo apt-get install tofrodos

Syntax: 
dos2unix filename

Example:
dos2unix script1.sh

To know more about this you can go through References.

References:
http://linuxcommand.org/man_pages/dos2unix1.html
http://www.thefreecountry.com/tofrodos/

If you have any further queries, please add your comments. You can also mail to psrdotcom@gmail.com