Discussions
Categories
Groups
Help
Home
User Community
Discussions
select items in a list box.
unknown
hi jmpers,
can anybody help on this?
I need to select items a list box. these items contain common characters eg.
select items contain "123" in this list box {abc123, ddd, eertf123oo,den123, bad,good,abc,edg};
Accepted answers
All comments
ms
If you with "select" mean to collect the matching items in a new list, the script below would do that. It may not be fool proof, but for your example it works.
aim
If you need to select several items in the display ListBox using specified pattern, try the following script.
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">lb_list
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
{
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"abc123"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"ddd"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"eertf123oo"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"den123"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"bad"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"good"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"abc"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"edg"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">ClearListBox
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Function
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
{
lb
}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
{
Default
Local
}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
clear_list
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Get
Selected Indices
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
nc
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Items
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> clear_list
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">For
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
nc
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
ii
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">++,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">
lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Set
Selected
(
clear_list
[
ii
]
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">0
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">MatchSelect
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Function
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
{
lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
pattern
}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
{
Default
Local
}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
ClearListBox
(
lb
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
lb_list
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Get
Items
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
nn
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Items
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> lb_list
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">For
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
nn
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
ii
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">++,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">If
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">!
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Is
Missing
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Regex
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">lb_list
[
ii
]
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">pattern
))
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 3">
lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Set
Selected
(
ii
)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">
)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">wndw
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">New
Window
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">""
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Border
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Left
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">5
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Right
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">5
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">
Top
(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">5
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">
Bottom
(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">5
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">V List
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 3">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Text
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Example
selecting multiple items in list box by pattern"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 3">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Lineup
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 4">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Col
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">2
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-spacerun: yes">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 4">
lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">List
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> lb_list
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 4">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">V List
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 5">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Button
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Select
rows with '123'"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
MatchSelect
(
lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"123"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 5">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Button
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Select
rows with 'a*c'"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
MatchSelect
(
lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"a*c"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 5">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Button
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Select
rows with first letter 'd'"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
MatchSelect
(
lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"^d"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 5">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Button
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Select
rows with 'oo'"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
MatchSelect
(
lb
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"oo"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 5">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Button
Box
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Close"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> wndw
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> close
window
)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 4">
)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 3">
)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">
)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
unknown
that really works!!! thanks guys. this looks like "find all". next step I'd like to do is "find next" and "find previous"......
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of
