lookup(all) exportcell

David Thompson dthmpsn1 at uiuc.edu
Fri Mar 7 10:08:59 PST 2008


>I'm trying to build an array of record values., without going to the 
>record. If I use lookupall(, I get all text values, but I lose all but 
>the first element of fields with CR's (as I would with exportcell). If 
>I use lookup(, I need to manually convert all values to text. 
>Exportline( is perfect, but it requires that the record in question be 
>the current record... which can spoil selection. Is there a way to 
>mimic exportline without requiring the record to be current?

An ArrayBuild treats each record in turn as 
temporarily current, so you should be able to use

ArrayBuild MyArray, sep, "", ?(KeyField=KeyValue, exportline(), "")

Dave


More information about the Qna mailing list