CSV problem with commas

MIT App Inventor Help
1

Hey there,

I've been searching for a solution to my problem: is that I have three values ("ha,ha", "hehe", "hihi") stored in a csv file i then store into a list. I want to pick the entire "ha,ha", including the comma, but the code doesn't allow it and only picks "ha", making the other part another value of the list. Does anyone know if it can be resolved?
Here I leave you some pictures of the code.

Here's some functional code (I don't think it needs to be changed):

pic1
pic1966×648 51 KB

Here's the important part, where I need to change the code:

pic2 to solve problem
pic2 to solve problem817×263 18.4 KB

If you wonder, global dia = 0, and global mida = 3.
Also, label1 and label2 will be deleted, it's just for me to see the results.

Thanks,
If you need I can share with you a copy of the project.

By the way, I've just seen that I have to finish the initial code, if global dia is in the list of tags of DATES.

2

Upload that.

3

Show exactly what you have here:

image

I am guessing: "ha,ha";"hehe";"hihi", and explain where it comes from in that format and why...

This is not valid csv formatting

4

excel
excel895×451 19.1 KB

So there is not any way I can do it?? Is there any format I can use instead? I really need to write commas in the "Significat_" variable.
I used csv format because it is the only one I've learnt. I could have used any other format but I honestly don't know...

5

You did not show the value of "text" as requested

Setting the locale of your spreadsheet to "en" may help.