Adding characters at the beginning and end of values in a column

[TechR21]

Hi,

I have below column "Tags"

What i want to do in power query editor is to add a "{" at the beginning and a "}" at the end of the values in the original column., so i dont want to have to create a new column.

So i get it like this:

How can i do this?

[Anonymous]

Hi @TechR21 ,

If you don't want to use the custom column feature, you can use the following formula:

List.Transform(#"StepName"[ColumnName], each "{" & _&"}")

, where [ColumnName] is the name of the column you want to add a prefix. This returns a new list with each element the result of adding "{" and "}"before the element in the original column.

Best Regards,

Stephen Tao

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

[TechR21]

This works but then i only keep one column as a result. My table has multiple columns.

I see now i didnt mention it above

[Anonymous]

Hi @TechR21 ,

That seems like the best solution is to create a new custom column as @mlsx4  said, then remove the original column and rename the new column.

Best Regards,

Stephen Tao

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

[mlsx4]

Hi @TechR21 

Create a custom column and do: "{"&[TAGS]&"}"

[TechR21]

is it possible to add these to the original column without creating a new one?

[mlsx4]

Hi @TechR21 

I don't really know but if you create a new column, you can remove the first, once you have the new one