Arjan-

If you have a text field with spaces between the multiple values, you can tick the Sidebar text filters option to reveal Text Tools (from the drop down), which reveals more filtering options for searching text. Using Text Tools, you can change the behavior of the filtering to select text that BEGINS with the specified characters ('Word prefix') rather than CONTAINS the specified characters ('Substring'). If you enter a search for two characters/strings separated by a space, the ALL/ANY option will appear to specify whether you want rows where ALL or ANY text strings in the field can begin with the specified characters. For example, if your text column field contains th text values 'apples' and 'pears' then setting the Text Tools options to Word prefix and entering 'ap pe' and selecting the ALL option when it appears will filter down to only records that contain both 'apples' and 'pears' in the text field being filtered.

Note you can search a numeric field using the same method. Let's say you want the numbers 110 and 120 only. Make sure the field is showing in the sidebar using the Devices drop-down. Click the device itself's configure button (a little black triangle next to the name). Or right-click the device title. Choose Filter type > Text search. From the same menu, choose Show text tools. Enter "110 120". Click the ALL button which will change to ANY (meaning 110 OR 120). Change Substring to Exact (meaning 110 or 120 should match the entire cell). This should be what you want.

Thanks, this works great.

Steve

Is it possible to have the ability to show/hide text tools in the viewer version? (rather than Profession etc) If I save an IOK with text tools visible in the device, a viewer (ie read-only users) can use the AND/ANY functionality and change the search options however if I forget to show text tools on a certain device when I distribute and IOK, the users cannot show/hide them themselves. As this functionality is available to viewers could the ability for them to to turn it on/off themselves be enabled?

Thanks

Andy

The viewer has the ability to view and filter pre-configured views, but not to change the configuration. This is intentional, in part to allow the interface to be simplified. If you wish a user to be able to search in this manner, you must configure the file appropriately.

Understood - thanks Steve.