Parse out alphabetic characters

From: May (hmtan_at_hotmail.com)
Date: 05/28/04

  • Next message: Andrew Gaffney: "weird math"
    Date: 27 May 2004 20:29:47 -0700
    
    

    Hi,
      I would like to parse out the same name between
      the new and old array , lists of new cells in new array and old cells
      in old array. But the scripts are not working right.
      Is this because the name of the array are in alphabetic ?
      Anyone could help me or advise please ?
      Thanks in advance.

          
            open(FILE4, ">same1.txt");
              open (FILE5, ">new1.txt");
               
           @new=(and2, nor2,mux3,mux4,nand6);
           @old=(and2,mux7,fill_7,mux4);
          
          
           $count1=4;
           $count2=3;
             $a=0;
              $b=0;
             while($a <=$count1)
             {
              
                {
                  if($new[$a] == $old[$b])
                      {
                        
                        print FILE4 "$new[$a]\n";
                        
                        
                         
                    }
                    elsif($new[$a] !~ $old[$b])
                    {
                        print FILE5 "$new[$a]\n";
                      }
                    
                    
                    $a++;
                }$b++;
             
              }
                  

           
           close(FILE4);
           close(FILE5);


  • Next message: Andrew Gaffney: "weird math"

    Relevant Pages

    • RE: excel formulas
      ... converts a number from euros to a euro member ... Counts the cells that contain numbers in a database ... Specifies a logical test to perform ... Looks in the top row of an array and returns the value of the indicated cell ...
      (microsoft.public.excel.misc)
    • Re: excel formulas
      ... member currency, or converts a number from one euro member currency ... Counts the cells that contain numbers in a database ... Specifies a logical test to perform ... Looks in the top row of an array and returns the value of the ...
      (microsoft.public.excel.misc)
    • Re: Excel Cell Formats
      ... Disable the update of excel. ... Copy the cells from this new sheet to my selection ... Someone suggested that I create a dummy 2D array containing my ... new ordering, but for my selection only, not the entire row. ...
      (microsoft.public.excel.programming)
    • Re: Array Declaration Problem ??
      ... cells B11:B14:: numerical values ... Function Zroots2 (ar As Range, ai As Range, m As Integer, polish As String) ... instead of returning the array 3 results to the 3 vertical cells. ...
      (microsoft.public.excel.programming)
    • Re: Excel Macro Filtered Data in-place: cannot calculate Frequency of Visible Cells
      ... What you could do, perhaps, is to use the Advanced Filter, set a criteria ... I have implemented your suggestion for a separate> named range object SET to the original range that contains the whole> un-filtered list, ... But the data> returned is still based on the whole un-filtered list and not the> filtered, Visible Cells only. ... >>> Returns a frequency distribution as a vertical array. ...
      (microsoft.public.excel.programming)