How to remove part of CSV.

[Mc Woodhouse]

I get the following response from the web1 GotText component. 

I set a label to the response and I see this.

1) TAG147, 999999999, 1000, 1000, 999999999, 1 

2) cdrw12, 123456789, 1000, 1000, 123455789, 1 

3) Dad737, 123456789, 1000, 1000, 123455789, 1

I do not want to show all of the CSV's how do I sort/filter out what I do not want?

Also why did the label put each row on a separate line? I thought it would be all on one line.

[Ghica]

You see the result on several lines because you received several lines.
How to sort this out, depends on what you want. You could convert your response content to a list of lists using "list from csv table text (your response content)". Then, go through the list using one of the "for each" blocks, and put what you need in some global variable, which you then display.

Some pointers to using lists:
List Blocks, by Sajal Dutta:
http://www.imagnity.com/tutorials/app-inventor/list-blocks-on-app-inventor/

Chapter 19 of the App Inventor book:
http://www.appinventor.org/bookChapters/chapter19.pdf

Displaying a list:
http://ai2.appinventor.mit.edu/reference/other/displaylist.html

Cheers, Ghica.

[Taifun]

what you are receiving is a table in csv format... the delimiter for each item is a comma, the delimiter of each row is the invisble new line character \n

usually you convert the csv table into a list using the list from csv table block

sorting/filtering lists is no simple task... it would be easier to filter/sort before receiving the data on server side

you can find solutions about filtering/sorting lists after doing a search here in the forum

this is one example How to sort a list using the webviewer(!)

see also

• How to work with Lists by Saj
• How to work with Lists and Lists of lists (pdf) by appinventor.org

Taifun

---

Trying to push the limits of App Inventor! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun. 

[Abraham Getzler]

Also see the SELECT and WHERE_EQ procedures in this Gallery app:

ai2.appinventor.mit.edu/?galleryId=6488648341520384

[Mc Woodhouse]

Thanks for the help! I was able to do what I wanted. I used the list from csv table text to save the response to a variable. I then used the  select list item list blocks to sort and display the list in a label.