Friday, 24 February 2017

Most useful books on CSS


Some useful learing books on CSS

CSS crop string in the middle


This article helps you to crop long string in middle using css ellipsis.

Most useful excel functions and examples

Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel.
There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, this functions will help you to enhance your ability.

Excel Shortcut Keys

This article describes what Key Tips are and how you can use them to access the ribbon. It also lists Ctrl combination shortcut keys, function keys, and some other common shortcut keys for Microsoft Excel 2013.

Keyboard access to the ribbon

If you’re new to the ribbon, the information in this section can help you understand the ribbon’s keyboard shortcut model. The ribbon comes with new shortcuts, called Key Tips. To make the Key Tips appear, press Alt.
To display a tab on the ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. This makes all the Key Tip badges for that tab’s buttons appear. Then, press the key for the button you want.

Sunday, 19 February 2017

Oracle NULL functions

Oracle have 5 NULL-related functions:

   1. NVL
   2. NVL2
   3. COALESCE
   4. NULLIF
   5. LNNVL

Folder locker using .bat file

Lock your personal data in password protected folder.


Here I am sharing you trick to lock folder without using any software.

Thursday, 16 February 2017

SQL interview questions and answers


JavaScript: Displaying number in indian format

Here is the solution for displaying number in comma seprated format in your page using javascript.

JavaScript: Regular expression to validate URL


Please find below JavaScript code to validate URL using regex expression.

function ValidURL(url) {
 var regexp = /(ftp|http|https):\/\/(\w+:{0,1}\w*@)?(\S+)(:[0-9]+)?(\/|\/([\w#!:.?+=&%@!\-\/]))?/;        return regexp.test(url);
}

C# : String Helper Class


Please find StringHelper class for working on string related functionalities

Javascript:Set cookie and get cookie


This post helps you to create , read and delete cookie in javacript.

Wednesday, 15 February 2017

Javascript: Function to get current fiscal year


Function to get current financial year from current date in javascript.

Play video with HTML5


Adding video to your page is easy as adding image. No extra plugins required, you can do it with single element