Forum Discussion

mcflurry's avatar
mcflurry
Helper I
5 years ago
Solved

Insert multiple characters to string

Hi,   I'm trying to insert a few "dots" symbol to a column with a custom column, but i can only get one characte, this worksr:   CustomColumn =Text.Insert(Text.From([Column]),2,".")   What if ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi mcflurry 

    Add a custom column like :

    Column=Text.Insert(Text.Insert([Column1],4,"."),7,".")

    And the effect is as shown:

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

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

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
5 years ago

mcflurry - Like this?

Text.Insert(
	Text.Insert(
		Text.Insert(
			[Column1],
			2,
			"."
		),
		4,
		"."
	),
	6,
	"."
)