Formatting: Removing Brackets and Quotes

Questions and Help
1

Hi Everyone, I have created a snippet using a google sheet import, and I have everything working the way I want, except the data is displayed between two brackets and quotes - how do I remove those?

Text-Blaze-Dashboard

{urlload: https://docs.google.com/spreadsheets/d/e/2PACX-1vR6t7hktmjXDvYTkeS3nsdDfGIeJIwLdv-c8IIRF5r3YQ7x557pyVH41XEgTDkWFi5jjCl1PEHLZOLo/pub?output=csv; done=(res) -> ["csv_data"=res]}
{chi=slice(split(replace(csv_data, "Chicago,", ""), "\n"), 2,2)}
We can have someone come as soon as {=chi}

2

Hi @Dano ,
The results (chi) is a list with one item.
What you're looking for is getting the first item, which can be done like this:
{=chi[1]}
Please let me know if you have any questions.

3

@Dan_Barak1 That did it, thank you so much!

4

@Dan_Barak1 next question, I got this to work, but I still get the pop-up dialogue that I than have to choose "Insert" on - is there a way to by pass that so when I type the snippet in it automatically inserts everything without the pop up dialogue?

5

Hi @Dano , have a look at: