search a number of on array

[Silvio.Falconi]

I have an array created with

AaDd(aFrequeMax[nRuota],{massimo, &num})

then I have a number for a sample 42 and the nWheel 1

I must found the number 42 on aFrequeMax [nWheel] and return me the second element of this array

How I must make it ?

I tried with
AEval( aData, { |a| If( (a[1] = numero ), nFrequenza:=a[2] , nil ) } )

[Antonio Linares]

Dear Silvio,

Please provide a drawing or something to better understand you

[Silvio.Falconi]

Dear Silvio,

Please provide a drawing or something to better understand you

sample nWheel = 1




I have to find out if my number is in the first column, if it found it, return the value for the second column

For a sample my number is 66 it must return 594

[nageswaragunupudi]

Code: Select all  Expand view  RUN

function ArrLookUp( aArray, nSeek )

   local nAt
   
   if ( nAt := AScan( aArray, { |a| a[ 1 ] == nSeek } ) ) > 0
      return aArray[ nAt, 2 ]
   endif
   
return nil
 

[Silvio.Falconi]

thanks