Search string

[Anonymous]

    hi

i  have  a requirement where i need to select all the data in list box except one string i.e Branch Segment . i need  to select all the values except branch Segment .

thanks

[tresesco]

Search string, something like:

='('&Concat({<YourField=- {'Branch Segment'}>} Distinct YourField, '|') &')'

or,

First trigger: To select brach segment

Second trigger: To select excluded

[its_anandrjs]

Hi,

In the list box write expression

Assume BranchDetails contains branch Segment and other details also

=If( Not Match(BranchDetails,'branch Segment')

or

If( BranchDetails <> 'branch Segment' ,BranchDetails)

Regards

Anand

[jagadeesh_diamo · Accepted solution]

First you select 'Branch Segment' then click on SELECT EXCLUDED.

[jagadeesh_diamo]

Good...