Pages

Sunday, May 20, 2012

VBA Comparison Operators


VBA Comparison Operators

Comparison operators compare two numbers or strings and return a logical (True or False) result. The main Excel VBA comparison operators are listed in the table below:
OperatorAction
=Equal To
< >Not Equal To
<Less Than
>Greater Than
<=Less Than or Equal To
>=Greater Than or Equal To


references:
http://www.excelfunctions.net/VBA-Operators-And-Functions.html

Tuesday, May 15, 2012

split integer value from others character



  #!/usr/bin/perl

  use strict;


  my $data = '2323424: 2434324, 3455543543';
  my @ftr =();
  my @values = ();
 
   @values = split(/(\d+)/, $data);

  foreach my $val (0 ..  $#values) {

unless ( $values[$val] =~/^[0-9]+$/)
{
splice(@values, $val, 1);

}

  }

  print " @values\n";
  exit 0;

Wednesday, May 2, 2012

Perl CGI for beginner

Good post for beginner:
http://www.perlmonks.org/?node_id=44536

Website to download apache : httpd-2.0.64-win32-x86-openssl-0.9.8o.msi
http://httpd.apache.org/download.cgi#apache24

 

site weekly hits