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

Oracel Database: Delete all user objects (Tables, Views, Procedures, Functions, Sequences, Types, Packages)

Hi friends,

I have come across a situation, where I need to delete all the user objects i.e. Tables, Views, Procedures, Functions, Sequences, Types, Packages.

Please find the link below for the SQL script, which does the job for you.

It's my public GitHubGist URL, where anyone can share the code snippets.

https://gist.github.com/psrdotcom/b61f8b401d4992428ecd8fb8225436c4

Advantage:
You can delete the user after deleting all user objects by logging into SYSTEM user.

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

Tomcat issue "windows could not start apache tomcat on local computer" after java update issue with resolution

Hi friends,

Today I have faced an issue with Tomcat service starting. I would like to share with you the resolution as well. Please find the details below.

Root cause

Updated java version

Resolution

• Navigate to you apache installed folder
• Go bin folder
• Double click on "Tomcat(X)w.exe" where X the version of tomcat.
• In my case it is "Tomcat8w.exe" because the version is 8
• 
• Select "Use Default". So that, it uses the JAVA_HOME version by default.
• Click on OK
• Start the Tomcat service and enjoy deploying

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

Consolidate / Merge all your PF accounts

Hi friends,

Today, I have come across one useful website which consolidates all your PF accounts under one roof.

Pre-requisite

1. You should have one active and current PF account
2. You should have UAN created and activated
3. You should have your old PF account numbers

Important Information

If you have changed organization, then wait till the previous employer update your "Date of Exit (DoE)"
After that your current employer details should be available
To verify that, please login to your UAN services account
https://unifiedportal-mem.epfindia.gov.in/memberinterface/
Go to "View" -> "Service History"
You should be able to see your present and previous employers
Note: You wait for atleast 3 months, after you exit from your previous organization

Procedure

1. Visit http://oeoea.epfoservices.com/UANDEDUP/index.jsp site
2. Enter your registered mobile number
3. Enter your UAN number
4. Enter your current active PF account
5. Once you login, you should be able to view your all registered and linked PF accounts
6. Consolidate all PF accounts by selecting and further processing

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

Change EOL (End Of Line) Character from Windows to Unix/Linux for all the files in current working directory

Hi all,

For a single file, you can do the change of EOL using notepad++.
Reference: http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from.html

But it would be difficult, if you want to do for multiple files in one go.

I have found a solution to update EOL for all files in the current directory.

Pre-requisite

Make sure that, working directory contains only the files which you want to change EOL.

Note: If not, copy the files to a new directory and change the EOL for all the files in that directory.

Procedure

1. Download dos2unix utility from sourceforge https://sourceforge.net/projects/dos2unix/
2. Extract the zip file
3. Tip: Make sure that the extracted path doesn't contain spaces.
4. Keep the bin directory available in your PATH environment variables
5. Download the customized batch file from GIST https://gist.github.com/psrdotcom/d73ff9590c3010253b5b2a886704b26b
6. Extract if needed, and place the "dos2unixfolder.bat" in the same directory where the "dos2unix" is placed.
7. Tip: If you place the batch file in the same folder of dos2unix.exe. You no need to add again the patch of batch file in environment PATH.
8. Navigate to your folder, where you want all the files EOL to be changed
9. Press "Right Click on Mouse" in empty area
10. 
11. Select "Open Command Prompt Here"
12. Type the batch file name "dos2unixfolder.bat"
13. You will able to see the conversion process
14. Once the conversion is completed, you can check the EOL coversion in notepad++.
15. If you need to help in checking, refer to http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from.html

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

Change EOL (End Of Line) Character from Windows to Unix/Linux using Notepad++

Hi all,

Today I will explain about updating/converting EOL for a single file from windows format to unix/linux format.

1. In Windows, the EOL (End-Of-Line) character is \r\n (CR LF) (Carriage Return, Line Feed)
2. In Unix/Linux, the EOL character is \n (LF) (Line Feed)

Check for EOL

If you open the file in notepad++, you will be able to see the EOL character by following below steps:

• Type the content and hit enter button on keyboard
• Choose menu "View -> Show Symbol"
• Check the "Show End of Line" option

• Now, you will be able to view "CR LF" special symbols in you file at every line end as show below

Update EOL

To convert the EOL from Windows (CR LF) to Unix (LF), do the following

• Click on "Edit" menu
• Choose "EOL Conversion"
• Select "Unix(LF)"

• Now, you can check the update EOL character in your file. Example conversion show below

This type of conversion useful, when you are updating file in windows and using the same file in U/Linux environment.

Batch File Update

For all files in one folder, you can follow my blog.
Reference: http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from_20.html

Send your comments and feedback to psrdotcom@gmail.com

Asus Zenfone 5 Clear Cache to speed up your phone

Hi all,

Today I will describe about clearing cache in Asus Zenfone 5 to speed up/boost your phone performance.

Pre-requisite:

• Take backup on your internal storage (Ex: Pics, docs, your important info)

• Make sure that, you have enough battery level or keep the phone in charging mode

Procedure:

1. Switch off your phone
2. Wait for 15 seconds
3. Press the power button and volume up button simultaneously until Asus logo appears on your mobile screen
4. 
5. By default, it will show "Normal Boot"
6. 
7. By pressing volume up/down button, you will be able to see the following options
8. Normal Boot, Power Off, Recovery Mode, Restart Bootloader
9. Select "Recovery Mode"
10. 
11. Press power button
12. Phone will automatically reboots
13. You will be able to see "No Command" on screen
14. 
15. Press and hold power button and volume up button simultaneously for 2 seconds and leave it
16. Now, you will be able to a screen with following options
17. reboot system now, apply update from adb, wipe data/factory reset, wipe cache partition, reboot to bootloader, power down, view recovery logs
18. Navigate by clicking volume down button to highlight "wipe cache partition"
19. 
20. Select using power button
21. You will be able to see fomatting cache message
22. 
23. Wait till the format completes
24. Once, it shows the format complete, select "Reboot system now" option

Enjoy the speedy Android flavor now.

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