listbox Filter

[#1]

Hi,

in my list box i have data like

Cloumnxyz
ABAB-CRDA-SA
AMERICA
ABSD-CRAD-IND
INDIA

by this way i have numer of rows, But i want only alternate rows data in the list box.

can it is possible, if possible plz give the solution

[morganaaron]

I'm gonna take a stab in the dark and assume what you're saying is you only want the rows that have genuine country names?

What format are the other values taking? You could exclude them in a if statement to find a certain character like the '-' you've got presented in them, you could consider splitting the values out into two fields...

You may have to clarify/expand a bit more on what you want first!

[arulsettu]

hi try this

if(match(Columnxyz,AMERICA,INDIA),Columnxyz)

[tresesco · Accepted solution]

If you want this filter at the script level, could try like:

Load

          Columnxyz

From <> where Mod(RecNo(),2);

Update: Similarly for front-end, listbox expression:

=Aggr(If(Mod(RowNo(),2),Columnxyz),Columnxyz)