Table.Column function return list in curly braces but i want chenge this to square braces

[Orkhan7]

Hi all!

My problem is to change the curly braces, when I want to use the Table.Column function, to square brackets. This is necessary for me because I want to make a curl request, but I need the values to be in square brackets.

Thanks!

[Anonymous · Accepted solution]

Hi @Orkhan7 ,

Table.Column returns the column of data specified by column from the table table as a list.

If you want to add change the items as [xxx], please convert list to table firstly

And then add a new column:

"[" & [Column1] & "]"

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnt75]

You could use Text.Combine, something like 

"[" & Text.Combine(Table.Column( whatever ), ", ") & "]"