<p> data, want </p>

95f04898-674b-4a03-a393-7da2e3623344 11 4 5 decimal

&[DATE] &[TIME] - &[FILENAME]

M key FindIndex r M rows : c M cols : 12 mat i 1 : j 1 : 12 mat j c ≤ (M i j el key ≠ (* i r < i i 1 + : i 1 : j j 1 + : 21 line if while j c ≤ i j 21 mat 0 if 41 line :

M 11212 4.5 42321144245 7.2 6454 mat :

key 6 :

row
col idx M key FindIndex (: 5321 mat

row
col M M Max FindIndex 5221 mat

row
col M M Min FindIndex 1121 mat

Find the 1rst element in vector that exceeds
 a prescribed threshold. V treshold FindIdx j 1 : V j el abs treshold ≤ j j 1 + : while j 1 - V j el 21 mat 31 line :

user i 0100 range : V 0.1 i * sin vectorize : 21 sys

idx V 0.875 FindIdx : 11 0.891 21 mat

Locate the 1rst occurence of a
specific element in a vector V x FindIdx j 1 : V j el x ≠ j j 1 + : while j V j el 21 mat 31 line :

user i 1500 range : V 101 i * cos * vectorize Ceil : 21 sys

E V 5 FindIdx : 20521 mat

Finding the first element in a vector that exceeds a certain treshold

v u 02 π * 0.1 range : i 1 u rows range vy i el u i el sin : for vy 31 line :

v tresh first j 1 : v j el abs tresh ≤ j j 1 + : while j v j el 21 mat 31 line :

v 0.5 first 7 0.5646 21 mat

v 0.875 first 12 0.8912 21 mat

index [indices] of integer search matrix/vector. No match = "idx_not defined"

M 12345648933 mat :

h 611526672316357553377120 mat transpose :

value table col lookup k 1 : j k table rows range table j col el value ≡ index k el j : k k 1 + : 21 line continue if for k 1 ≡ index NO match : index if 31 line :

4 M 1 lookup 2321 mat

6 h 1 lookup 1561141 mat

13 h 1 lookup NO match

Locating the first occurrence of a specific element in a vector

w v 1500 range : i 1 v rows range vy i el 1000 v i el cos * Ceil : for vy 31 line :

check if occurrence is unique

400 w 1 lookup 39711 mat

v x search j 0 : i 1 v length range j j 1 + : v i el x ≡ vv v i el : break 21 line vv NO match : if 21 line for j vv 21 mat 31 line :

w 400 search 39740021 mat

w 700 search 15070021 mat

w 145 - search 8145 - 21 mat

w 400 - search 500 NO match 21 mat

M V Locate Locate exclusive count 1 : i 1 M rows range j 1 M cols range M i j el V i el - 0 ≡ T i 1 el i : T i 2 el j : T i 3 el M i j el : 31 line count count 1 + : if for for T 41 line :

Locate specific 'v' in data table

Q 1.22 7.36 7.96 7.94 1.26 2.36 4.74 3.07 5.83 4.11 3.78 8.14 3.64 9.93 8.95 9.73 5.13 3.71 5.78 3.16 54 mat :

v 5.13 4.74 9.93 9.73 3.16 51 mat :

header row col v 13 mat :

Locate header Q v Locate stack :

Locate row col v 00023 4.74 00044 9.73 54 3.16 63 mat

Altitude correction from source [1..4] data 1.2929 1.2469 1.2022 1.1588 1.1523 1.1113 1.0714 1.0327 1.0392 1.0022 0.9663 0.9314 0.9464 0.9127 0.88 0.8482 0.8688 0.8378 0.8078 0.7786 0.8029 0.7743 0.7466 0.7196 0.7464 0.7198 0.694 0.6689 0.6972 0.6724 0.6483 0.6249 0.6542 0.6309 0.6083 0.5863 0.6161 0.5942 0.5729 0.5522 0.5823 0.5615 0.5414 0.5219 0.5519 0.5323 0.5132 0.4947 0.5246 0.5059 0.4878 0.4702 0.4998 0.482 0.4648 0.448 0.4773 0.4603 0.4438 0.4278 0.4567 0.4405 0.4247 0.4094 0.4379 0.4223 0.4071 0.3924 0.4205 0.4055 0.391 0.3769 0.4044 0.39 0.376 0.3625 0.3896 0.3757 0.3622 0.3491 0.3757 0.3624 0.3494 0.3368 0.3629 0.3499 0.3374 0.3252 224 mat :

search range value
"truth" condition lo 0.6309 : hi 0.8688 : 12 mat x c lo x ≤ (x hi ≤ (* : 21 sys

Nested exploder sorted row wise ... [row_col] M lo hi locate k 0 : i 1 M rows range j 1 M cols range M i j el lo ≥ (M i j el hi ≤ (* 0 ≠ u k k 1 + : el i : v k k : el j : 12 mat k k 1 + : if for for strip paired 0's k 0 : i 1 u rows range u i el v i el * 0 ≠ R k k 1 + : el u i el v i el 12 mat : 11 line NOT in search lo/hi if 11 line for R 31 line 41 line :

index data lo hi locate :

index rows 18

veritas cnt 1 : j 1 index rows range n index j el (11 el : k index j el (12 el : value cnt el data n k el : cnt cnt 1 + : 41 line for value 31 line :

data UnestV v data 1 el : j 2 data rows range v v data j el stack : for v 31 line :

index 4412 mat 5112 mat 5212 mat 5312 mat 5412 mat 6112 mat 6212 mat 6312 mat 6412 mat 7112 mat 7212 mat 7312 mat 7412 mat 8112 mat 8212 mat 8312 mat 9112 mat 9212 mat 181 mat

idx index UnestV :

header row col value 13 mat :

header idx veritas augment stack

Project header idx veritas augment stack :

Project row col value 44 0.8482 51 0.8688 52 0.8378 53 0.8078 54 0.7786 61 0.8029 62 0.7743 63 0.7466 64 0.7196 71 0.7464 72 0.7198 73 0.694 74 0.6689 81 0.6972 82 0.6724 83 0.6483 91 0.6542 92 0.6309 193 mat

Truth table T data c data * vectorize : 000000000000000 0.8482 0.8688 0.8378 0.8078 0.7786 0.8029 0.7743 0.7466 0.7196 0.7464 0.7198 0.694 0.6689 0.6972 0.6724 0.6483 0 0.6542 0.6309 000000000000000000000000000000000000000000000000000000224 mat

Locate exact value in vector V x FindIdx j 1 : V j el x ≠ j j 1 + : while j V j el 21 mat 31 line :

veritas 0.8482 0.8688 0.8378 0.8078 0.7786 0.8029 0.7743 0.7466 0.7196 0.7464 0.7198 0.694 0.6689 0.6972 0.6724 0.6483 0.6542 0.6309 181 mat

wanted 0.7466 :

E veritas wanted FindIdx : 8 0.7466 21 mat

Locate exact value in table M key FindIndex r M rows : c M cols : 12 mat i 1 : j 1 : 12 mat j c ≤ (M i j el key ≠ (* i r < i i 1 + : i 1 : j j 1 + : 21 line if while j c ≤ i j 21 mat end of search if 41 line :

row
col idx T wanted FindIndex (: 6321 mat

sanity check T idx 1 el idx 2 el el 0.7466

W 1.22 7.36 7.96 7.94 1.26 2.36 4.74 3.07 5.83 4.11 3.78 8.14 3.64 9.93 8.95 9.73 5.13 3.71 5.78 3.16 54 mat :

The truth table

search range value
"truth" condition lo 2 : hi 4 : 12 mat x c lo x ≤ (x hi ≤ (* : 21 sys

Nested exploder sorted row wise ... [row_col] M lo hi locate k 0 : i 1 M rows range j 1 M cols range M i j el lo ≥ (M i j el hi ≤ (* 0 ≠ u k k 1 + : el i : v k k : el j : 12 mat k k 1 + : if for for strip paired 0's k 0 : i 1 u rows range u i el v i el * 0 ≠ R k k 1 + : el u i el v i el 12 mat : 11 line NOT in search lo/hi if 11 line for R 31 line 41 line :

Truth table W c W * vectorize 00000 2.36 0 3.07 00 3.78 0 3.64 0000 3.71 0 3.16 54 mat

index W lo hi locate :

index 2212 mat 2412 mat 3312 mat 4112 mat 5212 mat 5412 mat 61 mat

index rows 6

n 4 : D index n el mat2sys : 21 line

W D 1 el D 2 el el 3.64

Vectorized Bolean sorted cols wise.
1. Unwrap the truth table  [U]
2. Strip '0' in  [V] the unwrapped U. M c Mc U M c M * vectorize : V U 1 col : i 2 U cols range V V U i col stack : for k 0 : i 1 V rows range V i el 0 ≠ R k k 1 + : el V i el : 11 line OUTER <lo/hi> if 11 line for R 61 line :

lo hi 12 mat 2412 mat

W c Mc 3.64 2.36 3.71 3.78 3.07 3.16 61 mat

W c Mc sort 2.36 3.07 3.16 3.64 3.71 3.78 61 mat

Mat i 110 range j 110 range Mat i j el i 1 - sin j 1 - cos + : for for Mat 21 line :

M δ j z k 1 : k M rows < i k 1 + : j j : i 1 ≥ (M i j el abs (* δ ≥ i i 1 - : j j 1 + : 21 line while i 1 < k k 1 + : if i 1 ≥ break if 51 line while i j M i j el 13 mat 31 line :

what is value
row 2, col 4 Mat 24 z 24 0.148521511792549 - 13 mat

Mat 1 0.5403 0.4161 - 0.99 - 0.6536 - 0.2837 0.9602 1.8415 1.3818 0.4253 0.1485 - 0.1878 1.1251 1.8016 1.9093 1.4496 0.4932 0.0807 - 0.2557 1.193 1.8695 1.1411 0.6814 0.275 - 0.8489 - 0.5125 - 0.4248 1.1013 0.2432 0.2165 - 1.1729 - 1.7468 - 1.4104 - 0.4731 - 0.2034 0.0411 0.4186 - 1.3751 - 1.9489 - 1.6126 - 0.6753 - 0.0012 0.7206 0.2609 0.6956 - 1.2694 - 0.9331 - 0.0042 0.6808 1.657 1.1973 0.2408 0.333 - 0.0033 0.9406 1.6172 1.9894 1.5297 0.5732 0.0006 - 0.3357 1.273 1.9495 1.4121 0.9524 0.004 - 0.5779 - 0.2415 - 0.6958 1.3723 107 mat

i j M i j el 31 mat

i j M i j el 13 mat

Locate the 1rst occurence of a
specific element in a vector V x FindIdx j 1 : V j el x ≠ j j 1 + : while j V j el 12 mat 31 line :

MM 123410 - 112181333 mat :

x 11 :

MM x FindIdx 61112 mat

M V Locate Locate exclusive count 1 : i 1 M rows range j 1 M cols range M i j el V i el - 0 ≡ U i 1 el i : U i 2 el j : U i 3 el M i j el : 31 line count count 1 + : if for for U 41 line :

Q 1.22 7.36 7.96 7.94 1.26 2.36 4.74 3.07 5.83 4.11 3.78 8.14 3.64 9.93 8.95 9.73 5.13 3.71 5.78 3.16 54 mat :

in 'Q' search
row/col  'v' v 7.36 4.74 5.83 9.73 5.13 51 mat :

MySearch Q v Locate :

plug 'π' in 'v'
result is 4 rows
'π' not found. MySearch 12 7.36 23 4.74 31 5.83 44 9.73 51 5.13 53 mat

table 1.22 7.36 7.96 7.94 1.26 2.36 4.74 3.07 5.83 4.11 3.78 8.14 3.64 9.93 8.95 9.73 5.13 3.71 5.78 3.16 54 mat :

value table col vlookup k 1 : j 1 table rows range table j col el value ≡ result k col el table j col el : k k 1 + : 21 line 0 if for result IsDefined result no match if 31 line :

8.95 table 3 vlookup 8.95 table 2 vlookup 3.16 table 4 vlookup 31 mat 00 8.95 13 mat no match 000 3.16 14 mat 31 mat

value table row col hlookup k 1 : i 1 table rows range table row col el value ≡ result row col el table row col el : k k 1 + : 21 line 0 if for result 31 line :

3.71 table 52 hlookup 000000000 3.71 52 mat

search range value
"truth" condition lo 3.16 : hi 3.16 : 12 mat x c lo x ≤ (x hi ≤ (* : 21 sys

Truth table W c W * vectorize 0000000000000000000 3.16 54 mat

want 0.4679 0.4542 0.4645 0.4520 0.4654 0.4524 0.4618 0.4503 0.4921 0.4799 0.4744 0.4622 0.4918 0.4799 0.4749 0.4626 0.4381 0.4251 0.4514 0.4400 0.4374 0.4258 0.4515 0.4416 0.4215 0.4121 0.4009 0.3925 0.4136 0.4048 0.3934 0.3861 0.4571 0.4443 0.4552 0.4419 0.4600 0.4483 0.4577 0.4457 0.4008 0.3903 0.3857 0.3753 0.4023 0.3903 0.3856 0.3739 0.4231 0.4093 0.4253 0.4132 0.4213 0.4077 0.4222 0.4103 78 mat :

data 0.4195 0.4099 0.4078 0.4001 0.4247 0.4163 0.4134 0.4074 0.5001 0.4884 0.4893 0.4777 0.5008 0.4910 0.4910 0.4818 0.4945 0.4802 0.4789 0.4659 0.4862 0.4723 0.4719 0.4585 0.4837 0.4692 0.4756 0.4615 0.4862 0.4729 0.4786 0.4662 0.4874 0.4786 0.4788 0.4699 0.4853 0.4765 0.4770 0.4682 0.4543 0.4443 0.4393 0.4309 0.4573 0.4486 0.4420 0.4357 0.4918 0.4798 0.4884 0.4769 0.4915 0.4800 0.4878 0.4768 0.4724 0.4167 0.4160 0.4050 0.4269 0.4171 0.4143 0.4047 0.4302 0.4125 0.4167 0.4000 0.4319 0.4132 0.4190 0.4015 0.4975 0.4861 0.5002 0.4875 0.4952 0.4851 0.4974 0.4864 0.4668 0.4525 0.4430 0.4299 0.4630 0.4495 0.4387 0.4264 0.4713 0.4563 0.4606 0.4462 0.4620 0.4464 0.4542 0.4381 0.4545 0.4433 0.4437 0.4332 0.4565 0.4467 0.4482 0.4392 0.5027 0.4848 0.5039 0.4855 0.5014 0.4839 0.5014 0.4834 0.5015 0.4863 0.4870 0.4728 0.4996 0.4834 0.4859 0.4719 0.4660 0.4569 0.4330 0.4246 0.4548 0.4464 0.4222 0.4126 0.4719 0.4592 0.4700 0.4598 0.4710 0.4588 0.4679 0.4584 0.4056 0.3927 0.3919 0.3833 0.4063 0.3914 0.3922 0.3820 0.4710 0.4584 0.4472 0.4361 0.4731 0.4611 0.4505 0.4406 0.5280 0.5138 0.5137 0.5008 0.5261 0.5121 0.5108 0.4983 0.5040 0.4946 0.5162 0.5072 0.5008 0.4929 0.5127 0.5056 0.3934 0.3872 0.3707 0.3654 0.3910 0.3817 0.3695 0.3611 0.4209 0.4076 0.4062 0.3945 0.4226 0.4104 0.4069 0.3965 0.4824 0.4718 0.4783 0.4683 0.4794 0.4681 0.4757 0.4663 0.4970 0.4869 0.4954 0.4855 0.5015 0.4905 0.5004 0.4901 258 mat :

Short form of advanced Locate Array1 Array2

want rows data rows 21 mat 72521 mat

truth table rectagular Array1 on descending deployed Array2
matched occurences collected wrt their [row/col] in Array1. Array1 Array2 Locate Unwrap an array in vector V Array2 1 col : i 2 Array2 cols range V V Array2 i col stack : for V locate matching occurences ct 1 : match 0 : k 1 V rows range row 1 Array1 rows range col 1 Array1 cols range Array1 row col el V k el ≡ (1 ≡ match ct 1 el row col 21 mat : ct ct 1 + : 21 line NO math occurences if for for for match 91 line :

Index data want Locate :

row
col Index 17721 mat 12821 mat 12721 mat 6221 mat 9621 mat 7121 mat 22121 mat 16721 mat 81 mat

8 want in data Index rows 8

[row col] Index transpose 17712 mat 12812 mat 12712 mat 6212 mat 9612 mat 7112 mat 22112 mat 16712 mat 18 mat