Skip to content

BD_INSTRUMENT_SEARCH

Henrik edited this page Apr 17, 2020 · 10 revisions

BD_INSTRUMENT_SEARCH(search; maxcount)

Help function to search for Instrument and InstId

Syntax Description Required Type Sample
search name of instrument yes string "abb"
maxcount return max hits. (default=1) no int 10

Search order

If name is full match with search. Then always first in hitlist.
If name starts with search. Then add first in hitlist.
If name constains in search. Then add last in hitlist.

Sample

=BD_INSTRUMENT_SEARCH("abb")

Return first instrument starts with "abb".
If maxcount is not added, only first hit is returned (default=1).

=BD_INSTRUMENT_SEARCH("ab";10)

Return top 10 Instrument with "ab" in name

Clone this wiki locally