List from CSV Row

[Simon Carter]

I am having some problems getting this to work (probably my own fault) but I consulted the online documentation for components, and this feature is missing. There is an entry for it in the links at the top, but it doesn't go anywhere. Has it been deleted because there is a problem with the List from CSV row component? or is it just an accidental deletion?

[SteveJG]

This works fine Simon

This may be what you are talking about:

list to csv row

Interprets the list as a row of a table and returns a CSV (comma-separated value) text representing the row.
Each item in the row list is considered to be a field, and is quoted with double-quotes in the resulting CSV text. Items are separated by commas.
The returned row text does not have a line separator at the end.

list to csv table

Interprets the list as a table in row-major format and returns a CSV (comma-separated value) text representing the table.
Each item in the list should itself be a list representing a row of the CSV table.
Each item in the row list is considered to be a field, and is quoted with double-quotes in the resulting CSV text.
In the returned text, items in rows are separated by commas and rows are separated by CRLF (\r\n).

list from csv table

Parses a text as a CSV (comma-separated value) formatted table to produce a list of rows, each of which is a list of fields.
Rows can be separated by newlines (\n) or CRLF (\r\n).

I think list from csv row  was just forgotten when the documentation was made.

I believe there is a problem in the documentation for list from csv table , however.     CR LF will cause problems (as done using Windows Notepad),  the break has to be LF only.

Regards,

Steve

[Taifun]

I believe there is a problem in the documentation for list from csv table , however.     CR LF will cause problems (as done using Windows Notepad),  the break has to be LF only.

 @SteveJG: if you think, there is a problem, then please prepare a small test project as small as possible, which demonstrates this issue for MIT to take a look at. Thank you.

Taifun

[Simon Carter]

Thanks very much, Steve.

Much appreciated.

Cheers

Simon

[SteveJG]

@ Taifun .... the issue has been discussed.     https://groups.google.com/forum/#!searchin/mitappinventortest/notepad$2B$2B/mitappinventortest/tzoNdh4HyYY/h29PAgP--YcJ   

There is a problem creating a csv table using Notepad ... the MOST common tool AI2 developers use as a text editor.  The larger problem is getting the erroneous/misleading documentation fixed.   :)

This is what a Notepad created csv table looks like:  

the  list from csv table component won't accept this.

Regards,

Steve

[Taifun]

@SteveJG: the issue from the link you mentioned is something else, which is not related to the list from csv table block and that issue already is on the list of MIT to fix

coming back to your current "issue"

I believe there is a problem in the documentation for list from csv table , however.     CR LF will cause problems (as done using Windows Notepad),  the break has to be LF only.

There is a problem creating a csv table using Notepad ...the  list from csv table component won't accept this.

I now prepared a csv file using Notepad running on a Windows 7 computer like this:

a1,a2

b1,b2

c1,c2

and uploaded that textfile into an App Inventor project (see attachment) and as you can see, the list from csv table block works fine

Taifun

[SteveJG]

@ Taifun .... thanks Taifun, I stand corrected.    When I last built a table csv, something was not working right; I erroneously thought the problem related to Notepad.  It did not.   I still do not understand the issue that originally balked at using the simple Notepad file with the list from table csv block.  Appreciate the time you took for the example.

--Steve