Words with [" "]

Hello!

I am trying to display a list of words from a .csv file that I published in Google Sheets. I am able to see my words, and everything is working, except that when the text displays it shows as ["my word"].
How do I get rid of the [" "] around the word?

Thanks so much for your assistance,
Heather

We need to see the spreadsheets, and the full URLs you are using.
Either export and post the .aia file, or
post a link to one of the spreadsheets.

Thank you so much for your help!
https://docs.google.com/spreadsheets/d/e/2PACX-1vRmZVohNZ24Smv3ielVSxlEBSZ1NYqZUZaRdNmLkQxNCvfv5ebXNL9GZb_7AqQtDEOC0ztJLSM8D62W/pub?gid=0&single=true&output=csv

It's a single column CSV, so you don't use the CSV table conversion block, which expects a second dimension.

Instead, use a Split At \n block to turn the text into a list of words.
(Though I see some of them have embedded spaces.)

1 Like

Yes!! This now works perfectly!
I am adding my new blocks (the change is in the "When Web1.GotText" group) in case anyone in the future is looking for it.
Thank you!
Heather

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.