Forum Discussion
Table.Column function return list in curly braces but i want chenge this to square braces
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!
Hi Orkhan7 ,
Table.Column returns the column of data specified by
columnfrom the tabletableas 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.
2 Replies
johnt75Super User
You could use Text.Combine, something like
"[" & Text.Combine(Table.Column( whatever ), ", ") & "]"Hi Orkhan7 ,
Table.Column returns the column of data specified by
columnfrom the tabletableas 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.