Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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!
hi try this
if(match(Columnxyz,AMERICA,INDIA),Columnxyz)
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)