TestingDriveThru: Challenge from last week - Comparing two large text or excel files

TestingDriveThru: Challenge from last week and How I dealt with it.

Challenge: Comparing two text or excel files


Initially, the challenge does look like simpler to read. 
But the challenging part is to Comparing Huge File which contains records more than 100k.

I was advised to use Araxis Merge. It is a Desktop App.
It has 30-day trial version and Commercial Version.
https://www.araxis.com/merge/index.en 

This is very simple tool. Easy to install in few steps.

Tool is self-explanatory. We just need to explore the options to try out.

When we Open the desktop the Araxis Merge. We see two split windows, to compare two files.

Note: We can compare 3 files also.






We can drag and drop the files into Text Comparison 1 and Text Comparison 2




Araxis Automatically compares the files. The Non-Matching text will be highlighted between two files.

We can generate the report of comparison. By clicking on the Report Option.





And it generates HTML Report:

It is simple to do and use in quick way.

Posted in | Leave a comment

TestingDriveThru: Challenge from last week - Count No.of Commas in excel column values

TestingDriveThru: Challenge from last week and How I dealt with it.

Challenge: Count No.of Commas in excel column values

Initially, the challenge does look like simpler. But the challenging part is to count commas if the column values contains more than 500+ commas.




So, I have used excel formula: Which can calculate no. of commas in the column value.

Excel Formula:  =LEN(A1)-LEN(SUBSTITUTE(A1,",","")) 




Posted in | Leave a comment

TestingDriveThru: Challenge from last week - Finding Old site url's on google search after new site is launched.

TestingDriveThru: Challenge from last week and How I dealt with it.


Challenge: Finding Old site URL's on google search after New site is launched.

  • Most of the times, when a new or redesigned site is launched, the old site URL's still remains on the google web search
  • Problem: If URL re-directions are not specified to the URL's displaying on google search, when a user clicks on the old site URL , It redirects to Blank/No content available pages.
  • This can reduce the Google page ranking or loss of ranking for the site.

  • Challenge: When the customer is not aware of the URL Re-directions to be done, Be proactive to find out the Old site URL's and inform the stakeholders to get the re-directions to them.
  •  How to Find:
    • Go to google search
    • Enter as -  site:svit.ac.in
    • This displays results of site urls starting with svit.ac.in
  • Challenge: Ok, we found the results. But how can we extract all these urls to a file ?
  • How can we do ?

    • Install the ginfinity plugin for Chrome. This will un-restrict the number of search results per page by seamlessly appending the next page of search results to the current list.
    • Drag and Drop Chris Ainsworth’s Extractor ‘bookmarklet’ http://www.chrisains.com/seo-tools/extract-urls-from-web-serps/  on bookmark bar.
    • Navigate to google search results of site:svit.ac.in
    • Then click on settings of google search 
    • Then click on Search settings
    • Then increase the results per page = 100


    • Then scroll down  the search results of :  site:svit.ac.in
    • Using ginfinity, it shows all pages results in a single page

    • Then click on Google SERP's Extractor Bookmark
It lists all the URL's and Anchor text for the results listed.


Now, we can copy the URL's from the results list.

Posted in | Leave a comment