Questions and answers about the LiveCode platform.
https://forums.livecode.com/
Code: Select all
MyArray["First Key is text"]["Now is the time for all good men to come to the aid of the party"]
MyArray["Second Key is also text"]["The quick brown fox jumps over the lazy dog"]
MyArray["Third Key is also text"]["The quick brown fox snarls at the lazy cat"]Code: Select all
local MyArray, tFilteredA
// Create numerically keyed array
put "First Key is text" into MyArray[1]["Level1"]
put "Now is the time for all good men to come to the aid of the party" into MyArray[1]["Level2"]
put "Second Key is also text"into MyArray[2]["Level1"]
put "The quick brown fox jumps over the lazy dog" into MyArray[2]["Level2"]
put "Third Key is also text" into MyArray[3]["Level1"]
put "The quick brown fox snarls at the lazy cat" into MyArray[3]["Level2"]
// FILTER the array
filter elements of myArray where each["Level2"] contains "brown" and each["Level2"] contains "dog" into tFilterA
breakpoint -- you can now inspect the found array in tFilterA - only one element returned
Code: Select all
on mouseUp
local MyArray, tFilterA, tKeys, tKey, tSubKey
-- Create Array structure
put empty into MyArray["First Key is text"]["Now is the time for all good men to come to the aid of the party"]
put empty into MyArray["Second Key is also text"]["The quick brown fox jumps over the lazy dog"]
put empty into MyArray["Third Key is also text"]["The quick brown fox snarls at the lazy cat"]
-- Search the array
put the keys of MyArray into tKeys
repeat with x = 1 to the number of lines in tKeys
put line x of tKeys into tKey
put the keys of MyArray[tKey] into tSubKey
if "dog" is in tSubKey and "brown" is in tSubKey then
put MyArray[tKey] into tFilterA[tKey]
end if
end repeat
breakpoint -- tFilterA contains a single array element
end mouseUp
I think the issue is which container you’re searching with either regex or “where”.bobcole wrote: Tue Dec 02, 2025 5:48 pm Simon:
Here is a possible solution. It was initially suggested by jacque.
See
viewtopic.php?f=8&t=39716#p234042
Bob
Code: Select all
on mouseUp
get fld 1
repeat for each line tLine in it
if "brown" is in tLine or "dog" is in tLine then next repeat
put tLine & return after temp
end repeat
answer temp
end mouseUpThe bit you’re missing is Simon’s post on this page where he wants to filter an array in the form:
And actually what he asking for is a way to filter the keys…Simon Knight wrote: Mon Dec 01, 2025 9:05 pm I have an array with text keys and more text as the values. How do I filter for two text values in an element?
I'm seeking an AND statement but can't find one at the moment.
For example lets say that MyArray contains the following:Code: Select all
MyArray["First Key is text"]["Now is the time for all good men to come to the aid of the party"] MyArray["Second Key is also text"]["The quick brown fox jumps over the lazy dog"] MyArray["Third Key is also text"]["The quick brown fox snarls at the lazy cat"]
I want to filter the array based on elements that contain "brown" and "dog" which should result in an array with a single entry.
Code: Select all
filterCode: Select all
eachCode: Select all
filter elements of MyArray with regex "fox"
filter elements of MyArray with regex "dog"
First off I'm a regex fan. I would use regex for everything if I could.bobcole wrote: Thu Dec 11, 2025 3:06 am To effect an AND, a command may be run twice.Code: Select all
filter elements of MyArray with regex "fox" filter elements of MyArray with regex "dog"
Code: Select all
put "Now is the time for all good men to come to the aid of the party" into MyArray[1]
put "The quick brown fox jumps over the lazy dog" into MyArray[2]
put "The quick brown fox snarls at the lazy cat" into MyArray[3]