After, few search on internet, I understood that using excel software we can eliminate these symbols in few clicks. I checked it as well. So, I can go ahead for other parts of the project. But, if you guys know to solve this, please share the idea here. It will be useful.
Hi, is it possible to add/edit/update/copy the data specifically from any single column/row/box of .csv file?
ChatGPT told that it is possible if we convert .csv into .txt and split either using \n or , and once more split either using \n or,. This will put each cell-data of the whole .txt file in listView and so it is possible to select any particular listview.element (ie, Single Cell Data) and if we use for-each loop also along with this then we can select any particular cell of each row.
ChatGPT is so wrong that we don't bother trying to correct its garbage.
We are here to teach people, not robots.
3 Likes
ChatGPT introduced mit ai2 to me. But,I can understand your point, il share the blocks to make correction ...
Help me to solve these SAF blocks. Am I put right Labels in the right places? and how can I complete the last block? Tell me about FilePath/StorageLocation etc.
The purpose is to open a .csv file and convert it into .txt file.
Once the file is converted to .txt file, I will split it using \n and place it in a listview (row data). Then within forloop, Il again split the row data using 'comma' and get each cell value of each row in a listview (I guess).
From those cell values, I want only two of them from all rows. That is the goal.
Please, Guide me to correct the above SAF blocks. Thankyou.
I want to open .csv file, so what do I have to put in this box?
Thankyou. I understood.
In that block, type (mime type) and extramimetypes are asked. Okay, il check it.
Read the documentation
and the complete thread to find several examples
Taifun
Il check it, Do I have to include permission blocks?
After only 2 minutes you are already asking instead of working through that thread, which has 366 posts to find the answer yourself
Taifun
3 Likes
I read that once before. I shall read it again.
Okay, I almost solved it. Thankyou.
Hi, @TIMAI2 , how can i ignore the same data if that data already exists? I tried like this, but not working. Can you help me with this?
I am pretty sure you Need to fill ALL sockets.
1 Like
Attempt to correct these SAF blocks. Your ideas are welcome.
Actually, I want to upload .csv file from phone and put the data in google sheet. So, what is the role of SAF here?