Hi
I have a list of words in a file, one per line. I want to load this into a list.
I can use “list from csv table”, but each word is loaded as a list of one item (so for example [“abacus”] ).
“list from csv row” doesn’t work because the data isn’t in a row.
The list is too long to convert item by item to the format I want (abacus ).
Help please!
ABG
January 2, 2020, 7:40pm
4
Considering the double quotes, this might work better:
The peel blocks are draggable directly into your Blocks Editor.
Here is how to convert entries on a spreadsheet to a csv, then use that csv to create your List.
Post your elements in a spreadsheet like OpenOffice using your computer.
Export your data as a csv file to your computer desktop; most spreadsheets have that capability.
Compy the csv file to Media
In your Blocks, create two variables, perhaps called theCSV and theListFromCSV
In the app, load the csv from Media into theCSV variable as text
In the app, set theListFromCSV to list from csv table theCSV
Happy New Year,
Steve
Thanks everyone.
Steve - I may have misled you. The list is already in csv format - I meant the list is too long to individually “peel” the items to a new list in AI2.
In the end ABG’s “split at \n” worked a treat.
Jeremy
I should add that the list was nearly 400,000 items long!
1 Like
codo
March 31, 2020, 6:51pm
9
With a list of about 200 items, individually querying a single line from a Google Spreadsheet worked alright. But for 200+ individuals items, perhaps querying a spreadsheet for a different file type of each item.