developer-tips

How to extract rows based on regular expressions There are two ways to extract or filter records from excel using regular expressions. 1.        Using Home->Sort & Filter ->Filter 2.        Using Data->filter->advanced We have the below excel document and we need to extract the rows based on name which contains ‘John’. Approach 1 Step 1: Click Home->Sort & Filter ->Filter Click on ‘Last Name’ drop down and click ‘Text Filters’ and then click ‘Contains’ Write the word that you want to filter with, in this example it is ‘John’. The result is as shown below. If you want to have an AND condition with another field that can be done by using repeating above for that field. Below example filter excel based on Country column as well. The result is as shown below. Approach 2 Step1: Create an entry as shown below at column I (or any empty column...

Did you get an error saying "DNS PROBE FINISHED NO INTERNET" on the web browser and not able to connect to any websites. If so please try below steps to solve the issue. NOTE: This tutorial is specific to windows 7. Please expect some changes for other windows versions. STEP 1: Open command Prompt, Type 'cmd' and run as administrator as shown below. STEP 2: Run the following commands in order ipconfig /all  ipconfig /flushdns  ipconfig /renew  netsh int ip set dnsservers "wireless network connection" source=dhcp netsh winsock reset  NOTE: If you are facing problems with LAN connection ( Wired internet connection) then use below command instead of   netsh int ip set dnsservers "wireless network connection" source=dhcp netsh int ip set dnsservers "Local area connection" source=dhcp Please let me know if this works or if any issues.