How to select the 5th column from a csv table?

I’m so close,

I’m returning the recordset from MySQL. I can see them on the phone.

but I’m just not able to isolate te fifth (5th) item

What am I doing wrong???

Now it seems to b catching the 5th Recordset when what I want is the fifth ITEM in each record!

Thanks

What does that mean? You put index = 5. You read N items
banana
Apple
orange
watermelon
grape
pineapple and had item 5 recorded, grape N times.
Try Blocks :

Is in list
Contains

If not is in list [ not active ]
Or
If not contains [ not active ]
Add itens to list…

Hi Rogerio

You know how long I’ve been at this.

So here’s the thing.

I have a table right.

Im successfully querying and isolating the LIMPOPO province, NO PROBLEM (my php works)

I am NO LONGER CONCERNED whether it has the [NOT ACTIVE] or not.

Ive settled just to retrieve the 5th (fifth) item from each recordset it returns. In stead, what its giving me (time and time again ) is the fifth record set.

banana grow in trees [today]
Apple are tasting fantastic [this] year
orange are too sour [this] year
watermelon and me dont [go] together

Im trying to isolate the 5th word.

Thats it!!

Please … who is your fifth item?

1 Like

Try this

1 Like

Ok, we are getting close.

What you see is a list of all the records from LIMPOPO.

What I need is the 5th Item OUT OF EACH RECORD.
(look at the recordset under your 3)
-1----------2--------------------------3----------------4 --------------5-------------------------6
(135 LIMPOPO Sekulo District Municipality 0 Greendaal - [NOT ACTIVE] 0

I need the 5th Item in the record, ONLY

Thanks

Your Solution.
Without effort. Soon You Will have the aia

Guys, I already have it working as a REGULAR LISTVIEW but that is NOT what I need

I need the data to go into a LISTVIEW WITH IMAGE AND TEXT.

Now I dont know if a regular listview with words one under the other works together with a LISTVIEW WITH IMAGE AND TEXT. (but I already have a regular list operational)

This works

Do you use listpicker or listview with images ?

If you want to use listview with image

1 Like

List View image and Text

Please may ask you to look at my blocks and show me where I am wrong!

cause this is what I get

and my email is anthony(underscore)lange at outlook (dot) com

I already have this… but it looks horrible

and Now Its adding another *5th :slight_smile: each time???

If you only need the value of 1 field in your table (fifth field 5) select to take only that field.

Select yourfield from Yourtable

So you will only have response content values. Polokwane, Gyiani, Groblesrdal, Thoroyandou, Modimolle …

Hi,

Thats what Im doind. You can see the index is set to 5 BUT

iM GETTING THIS

No, you are not doing as I suggested. You are doing a Select with multiple fields. And the fifth field is what you want to use in the list view. By doing a Select command with 1 field only, you will not use index 5, you will use index 1. The classification [off-air] must be stored in a field separately and not next to the name "Bela-Bela [off-air]

Ah, I think you didnt see this… Ive given up on that one a long time ago…

All I want is the name and the status together.

My php is a broad select cause I am using all the other data elsewhere

Im getting the data back in a listview - NO PROBLEM

but I need it in a different format - Listview with image and text

Title should only take (Select) 1 item from your List and not the whole list. Light blue block Select item.

1 -you have a list with several fields
2 - create a sublist of the main list, taking only the 5th field.
3- do one
for each
from 1
to lenght of sublist
by 1
put that sublist item in your title

Title should only take (Select) 1 item from your List and not the whole list. Light blue block Select item.

*** so im going to replace the long tag currently in the [title] with an [Item} tag? ***

1 -you have a list with several fields

*** correct *****

2 - create a sublist of the main list, taking only the 5th field.

***** how? ****** and where does it go?

3- do one
for each
from 1
to lenght of sublist
by 1

*** I thought that seeing as I’m already in a for each [item] in list block I don’t need another counter??? That’s what I don’t understand???

Thanks guy. I know your doing your best to help me. Cant you just do a mock layout.

Thanks

put that sublist item in your title

You already did.

ok, so what next???

Next
Step …

yes, Listview with image and text
Ive done that and I get the increasing list. Everytime a new town added to the one above.