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

Windows file name too long to delete move copy rename due to destination path too long

Hi friends,

Problem

When i am clearing my old windows folder from the OS installed drive, I had an issue of deleting the files and folder because the path name is too long.

The error message is

"Destination Path Too Long.

The file name(s) would be too long for the destination folder. You can shorten file name and try again, or try a location that has a shorter path."

Background

Windows OS will allow the file path to be max 255 characters. If any file or folder path is beyond 255 characters, you will not be able to perform any file actions like delete / move / copy / rename.

Solution

1. Navigate to the folder in the windows explorer
2. Type the following command in the address bar and hit enter key
• subst j:
3. Open a new windows explorer window
4. Now you will be able to see new drive with letter J:
5. You will be able to delete the files/folders with in the drive
6. To delete the other files, navigate to the parent folder and delete one after one or multiple folders path at a time.

Please send your feedback or suggestions to psrdotcom@gmail.com

E Aadhaar password for mail copy PDF received from aadhaar@uidai.gov.in

Hi friends,

I have updated my Aadhaar details from Aadhaar update center.
It is mentioned that within 72 hours, my details will be updated.

Before 72 hours of my updated application, I had received an email from aadhaar@uidai.gov.in with an attachment which is password protected.

As I was unable to find the password to open the file in the sent mail, I have googled to find the answer. I have found mulitple options. You can try the following procedure to open the file with your password.

Procedure to open the document

1. Download the file
2. Rename the file by adding .pdf extension, if missing
3. Try the following passwords
• Password length is 8 characters
• First 4 characters of your name as mentioned in Aadhaar card (All small letters)
• Next 4 characters are your year of birth which is mentioned in Aadhaar card
• Password length is 6 characters
• Pin code of your address as per Aadhaar records
• Pin code of your enrolled area where you have applied the Aadhaar card
4. For me, 8 character password (first 4 characters of my name as mentioned in Aadhaar card + year of birth) worked.

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

Get MMID of your Citi Bank Account

Hi all,

Today, I would like to share how to get MMID of your Citi bank account.

Send SMS to 52484 in the below format from your registered mobile number

MMID XXXX

Note: XXXX is your Citi bank debit card last 4 digits

Ex: MMID 1234 to 52484 where 1234 is your Citi bank debit card last 4 digits

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

Microsoft Excel Select a value from a predefined list of values with dropdown option to validate the data

Hi friends,

When I was preparing a sheet by referencing some pre-defined names as list to a field/cell. I was thinking the feature of Microsoft Excel dropdown list. After exploring the option and using, I thought of sharing with you all.

Objective: Selecting a cell value from a list of pre-defined values

Procedure:

1. Open blank excel workbook
2. Prepare you template with headers
3. Create a new sheet and rename it. Ex: "Names"
4. Enter the values from Column A from cell A1 in vertical direction
5. Don't use any other columns
6. Don't leave any empty cell in between the values
7. Leave first cell as empty, if you want to include the empty option in a dropdown
8. Select the cell which contains the values
9. Right click and choose the option "Define Name"
10. Give a name to the list of values. Ex: NamesList
11. Click on "OK" button
12. Now, move to the sheet where we want to use the list of names as a dropdown option
13. Select the cell(s), where we want to have the dropdown list
14. Click on "Data" Menu
15. From "Data Tools" ribbon, click "Data Validation" from "Data Validation" submenu
16. In Settings tab, Validation Criteria section, for the option Allow, select "List"
17. Choose the options
• Ignore blank: Ignore when user no selected any option
• In-cell Dropdown: Show the dropdown list in cell
18. In "Source" field, type the defined name for the list preceded with = (Equal to) symbol. Ex: =NamesList
19. Now, you should be able to see the dropdown with empty values
20. Select the predefined values from the dropdown list of names.

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