Checking format of Email address in excel

Checking email addresses in bulk if the format is correct or not

So in your excel sheet if emails are in A column, go in the B column or other and as per column name put alphabet and row number like B1 cell and copy paste this code: 

=AND(NOT(ISERROR(FIND("@",A1))),NOT(ISERROR(FIND(".",A1))),ISERROR(FIND(" ",A1)))

In formula you can see A2 because A1 is occupied with head column of excel data, After that drag mouse down from B2 it will automatically change the cell row number in formulas or you can copy and paste the code to the other cells. But with respective rownumbers change i.e.

=AND(NOT(ISERROR(FIND("@",A1))),NOT(ISERROR(FIND(".",A1))),ISERROR(FIND(" ",A1)))

 For all the valid e-mails, it will give you ‘TRUE’ and for the invalid ‘FALSE’.

Loading gif image for freeze page to process ajax request in jquery

The method is use to show some animated image at time of processing the ajax request with gif image. where we have to use beforeSend object in ajax call for loading gif at time of request processing.

Your ajax function looks like 

$.ajax({
    url: uri,
    cache: false,
    beforeSend: function(){
        // show gif image when request sent
    },
    complete: function(){
        // hide gif image when response receives
    },
    success: function(html){
       // final output hadleling
    }
});

Html Code:

<div class="loading">
  <img src="//image path" class="img-responsive" />
</div> 

Styling CSS Code:

.loading {
  visibility: hidden;
  background-color: rgba(255,255,255,0.7);
  position: absolute;
  z-index: +100 !important;
  width: 100%;
  height:100%;
}

.loading img {
  position: relative;
  top:50%;
  left:50%;
}

Jquery Code: 

$.ajax({
  type:'POST',
  beforeSend: function(){
    $('.loading').css("visibility", "visible");
  },
  url:'/quantityPlus',
  data: {
   'data1':p1,
   'data2':p2,
   'data3':p3},
   success:function(data){
     // data fetch and show on html page
  },
  complete: function(){
    $('.loading').css("visibility", "hidden");
  }
});

}

Check current date falls between two dates function in jquery

         The function is to check date comes between start and end date which should be in "dd/mm/yyyy" format.

function dateCheck(dateFrom,dateTo,dateCheck) {

 var d1 = dateFrom.split("/");
 var d2 = dateTo.split("/");
 var c = dateCheck.split("/");

 var from = new Date(d1[2], parseInt(d1[1])-1, d1[0]);  // -1 because months are from 0 to 11
 var to   = new Date(d2[2], parseInt(d2[1])-1, d2[0]);
 var check = new Date(c[2], parseInt(c[1])-1, c[0]);

    if(check > from && check < to) {
        return true;
    }
    return false;
}

Calling method

var availability = dateCheck(startTheoryDate,endTheoryDate,currentDate);

And finally it returns boolean value weather it is true or false.