Use of regular Expression to stripe off string part from Age (e.g, 10/10y/10 y/10year/10 year/10 years) in PHP. $age = “30 years”;//$age = “30”;//$age = “30y”; if ( preg_match(“/(\d)(\s)(\D*)/i”, $age, $match)){ if( is_numeric($match[1]) ) $age_num = $match[1];}echo $age_num; The output will be 30.
Continue Reading
You may want to create a backup or archive of your data from various google products including Gmail. This is a pretty straight-forward but a little time taking if you have got to use numerous google applications. You have to select the applications and the specific formats for each to include in the backup. From […]
Continue Reading
View Selection Formula: Get the records of the last 15 working days. This is achieved by calculating total days (TotDays) by moving back from now() and excluding all sundays (weekday=1). So for instance, If there are 3 Sundays in this period then we have to take 15+3=18 as TotDays (total working days) to get the […]
Continue Reading
If you want to be able to quickly access a particular website, you can add its address to your Home screen. Follow these steps:
Continue Reading
A launcher is an app that enables you to launch other android apps. The launcher governs the way your device’s Home screen and other main screens appear, including any live widgets you place on them. Android includes a default launcher that runs by default and which you invoke every time you press the Home button. […]
Continue Reading
Android’s Smart Lock feature allows you to set up methods of unlocking your device other than your pattern, PIN, password, or fingerprint. Setting up Smart Lock is pretty straight-forward. Locate Smart Lock option somewhere under Settings -> Security. You’ll be required to enter your password, PIN, or pattern to prove your identity. Next, choose the […]
Continue Reading
Sometimes it is required e.g, to get a comma-delimited-values list in a field from a relational database table. This is only possible to find some way to concatenate rows of the table. Following is one of the possible solutions using ‘FOR XML PATH’ expression in T-Sql. You may find other solutions as well. Suppose you […]
Continue Reading
Enter multiple commands at onceAdding && between commands will let you enter multiple lines at once to be executed in succession. e.g, tasklist && netstat -b List every device driver on your PCThe following command line displays the list of device drivers on your PC driverquery /FO list /v Output results to text file or […]
Continue Reading
A couple of very simple and intuitive code examples to parse data received in JSON format: var resultJSON = ‘{“FirstName”:”John”,”LastName”:”Doe”,”Email”:”johndoe@johndoe.com”,”Address”:”123 dead drive”}’;var result = $.parseJSON(resultJSON);$.each(result, function(k, v) { //display the key and value pair alert(k + ‘ is ‘ + v);}); Or var obj = $.parseJSON(resultJSON);for (var prop in obj) { alert(prop + ” is […]
Continue Reading
Losing your smart device can be drastic and painful, specially when you have a collection of sensitive and/or precious data. Financial loss could be tragic, for quite some time. With panic stricken face you may rush here and there in search of it. There’s a strong hope!!!Log in to this page: https://www.google.com/android/find?u=0 from a PC, […]
Continue Reading