Thankyou all out of my humbleness for everyones wonderful help and guidence. Tonight, Il somehow solve this error.
After asking to ChatGPT, I understood that the For Each Loop is not a compulsory thing for my LIST-VIEW app and it is necessary only for the app that needs to filter or modify the data before displaying it in Listview.
So, I am going to surgically remove the for-each block from the app-blocks and going to apply what @TIMAI2 shared above. Hope, the .csv output will be produced effortlessly after that as expected.
I removed away the header-data from the for-each loop and joined it with row data later just before saving the file in mfile component. Only, row data that is responsible for getting user inputs is within for-each-loop.
So, now I am getting the header data and row data at the right place.
But, I need to modify the .csv file little bit more. ie, I don't want symbols like 'quotes, coma, square brackets etc.' that are shown around certain data.
How can I remove that, like shown in the below picture?
I tried, but I don't know to do it, can you help me?
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.