Regular expressions provide a short and flexible means for identifying particular text; characters, words, or patterns of characters. You can extract emails, proxies, IP addresses, phone numbers, home addresses, HTML tags, URLs, links, dates, and what’s not? Regular Expression is a language of its own. Whatever programming languages you have already learnt, will help very […]
Continue Reading
Android phones dominate the cellular phones market with 2 billion monthly active devices globally.Android gained traction with device makers because it’s open source and free and Android phones have a wide variety of makes, models, and versions, and of course, the features. Google is always way ahead of other competitors in adding new features and […]
Continue Reading
The formula below subtracts one date (ketp in B1) from another (kept in B2) and divides by 365. The INT function then eliminates the decimal part of the result: =INT((B2-B1)/365) Although it servers the purpose to a large extent but if there’s a matter of accuracy, it fails because it divides by average number of […]
Continue Reading
Generate a list of files from the OS directory specified in a cell using MS Excel. Start with a Excel Workbook and follow these steps to create a named formula. From the Formula menu choose Define Name -> Define Name From New Name Dialog box provide formula name, say FilesList. Leave Scope to Workbook. In […]
Continue Reading
Sitting at home in casual dressing, sleeping all the day and working throughout the night, with no need to sustain office decorum. Working whenever you want to and spending time, almost as you wish. And all the while supporting your country’s economy. There’s a lot to like about the all relatively new, unconventional yet very […]
Continue ReadingWelcome to ITPrecinct.com!!! My primary intent of creating this blog is to not only share my knowledge, i have gained over the years during my professional career and working as a freelancer but also make it more like fun by creating tips, tricks and techniques about Information Technology and related spheres. I’m obsessively passionate about […]
Continue Reading