Forum Discussion
Solved
How to separate a string based on repetitions and string size.
Hello, I would like support in a situation where I am having difficulty. I have a column in text format that contains several numeric characters of undefined sizes. My objective is to standardiz...
=Table.TransformColumns(PreviousStepName,{"ColName",each Text.Combine(List.Transform(List.Split(Text.ToList(Text.From(_)),7),Text.Combine)," ")})
=Table.TransformColumns(PreviousStepName,{"ColName",each Text.Combine(List.Transform(List.Split(Text.ToList(Text.From(_)),7),Text.Combine)," ")})
Thanks for the support!! It Works!
Best Regards!