Thanks for your immediate reply. Here's the fetching of my data. When I decrease the csv file down to 30 lines of text, everything works fine. But 1000 records is only to dream on. My lines of text - simply words. Short - 3 to 8 letters. So, the app is like a dictionary for kids.
Please provide an example of a few rows in your csv?
Your list picker Elements should be CSV rows from splitting the CSV table text at \n
You use the wrong list picker event.
You need the After Selecting event.
The Selection value is the CSV row you can parse with no messy '(' and ')' residue.
P.S. you were running in n squared time
(Canned Reply: ABG- Export & Upload .aia)
Export your .aia file and upload it here.
.
Try like this:
When you click the Listpicker button (or launch the listpicker) you should see your list without rounded brackets.
A very long list will slow down the listpicker...
That's true! So far my list has brackets, as you may see on a screenshot of my phone. Thanks for the idea, I will try to get rid of them, appreciate your help.
Aha, now I see what you mean!
I will load my .aia as soon as I add the suggestion of TIMAI2
But what do you mean by "you were running in time cube"?
Just time squared.
Let n = the number of Elements ypu expect in the List Picker.
In the circled section, you walk through the rows of the downloaded table (n rows), and for each of those n rows you load the ENTIRE Elements list from that ParseCSV procedure, instead of just adding a single item from the current row.
So that's n * n = n squared time.
A single column CSV table is a pain to process, since each row is a list of a single item.
For such an input, it's easier to just split it at \n and get a simple one dimensional list.
That way, you avoid trying to cram a list into an Element, and avoid unnecessary sublist conversion into text.
Hmmm. Oh, my LORD!!!!!
What a disgrace, such mistakes bring me down.
Quickly change the blocks.
I don't have your aia, so the best I can do is show a sample:
TIMAI2, I reassembled according to your blocks and the result reall suprised me.
That's great!
FileControl_TIMAI2.aia (6.0 KB)
You do not need to parseCSV anything, this is already handled.
Just use the ListPicker.AfterPicking event to get your selection.
Where is that rounded bracket coming from ?
Here is my example aia project:
getCSVData.aia (2.6 KB)
and the csv data:
apple
orange
banana
mother
father
son
daughter
ball
bat
biscuit
bicycle
This is a list of lists:
[["apple"], ["orange"], ["banana"], ["mother"], ["father"], ["son"], ["daughter"], ["ball"], ["bat"], ["biscuit"], ["bicycle"]]
Oh, and just confirm you have this checked:
Rounded bracket? Let it go! That's a smile. Now I need to combine two solutions in one.
Nope, it is an error...
For your longer lists, try adding the FilterBar to help with finding something in the list