Split text

I am sorry to ask something really basic but i can't find the answer....

I have a list that give me:

(1,abcd,60,0,0,0,0)

(2,ad,59,0,0,0,0)

(3,bcd,58,0,0,0,0)

(4,acd,57,0,0,0,0)

I want to keep only the letters and remove everything else.

I was thinking about:

For each item in list

Then make each text as a list and select item 2.

Is that a good way?

--

Could you please provide us some screenshots of blocks?

--

Sure!

 

-- 

I was thinking about:
For each item in list
Then make each text as a list and select item 2.
Is that a good way?

yes

-- 

See this doc for how to do it with tables ...

Build Your Own DB - Part 1

-- 

That was so stupid...

But i am still block!

If you watch the screen, the foreach does not work...it gives me empty list... but if i do use all the block (the green circle) it works...

I want to create it for 35groups so i would really like to use a foreach...

Any idea?

-- 

this looks very cumbersome

learn how to work with lists of lists...

⦁ How to work with Lists by Saj

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

-- 

set the the variable in the loop to global instead


--

change the the variable in the loop to global instead


--

Thank you, i will work in this way!


--