searching an array?

2013-04-04 Thread Chris Sheffield
Okay array experts. I need help. :-) Is there any way to search and/or filter an array? I'm not finding anything in the docs, but I probably don't know what I'm looking for. My only thought was to use combine to convert the array to a list, and then use the filter command to locate what I

Re: searching an array?

2013-04-04 Thread Andrew Kluthe
Not that I have seen or come across. Although, people on the list come up with some pretty neat (and fast) search routines for things. On Thu, Apr 4, 2013 at 10:31 AM, Chris Sheffield cmsheffi...@icloud.comwrote: Okay array experts. I need help. :-) Is there any way to search and/or filter

Re: searching an array?

2013-04-04 Thread Mike Bonner
it might be possible to arrayencode the array and search that. If its a text only search it doesn't look like this should be too awful bad as long as key names and text entries stay clear text (it seems they do) Looking at the data there is a definite pattern. Would it be worth it? Probably

Re: searching an array?

2013-04-04 Thread Peter Haworth
I've usually just bitten the bullet and done it with nested repeat loops going through the various levels of keys. It's pretty simple code and I've always found array handling to be extremely fast so unless you have huge numbers of keys, it will probably work fine. Pete lcSQL Software

Re: searching an array?

2013-04-04 Thread Mark Talluto
On Apr 4, 2013, at 8:31 AM, Chris Sheffield cmsheffi...@icloud.com wrote: Okay array experts. I need help. :-) Is there any way to search and/or filter an array? I'm not finding anything in the docs, but I probably don't know what I'm looking for. My only thought was to use combine to

Re: searching an array?

2013-04-04 Thread Chris Sheffield
Thanks, Mike. Eventually this data will be stored in a SQLite db. I'm just working on a proof of concept right now and am not quite ready to create the database. I'm not sure about using arrayEncode(), as it returns a bunch of binary gobbledegook that may be difficult to decipher, but I may