Forum Discussion

Regular Visitor

3 years ago

Solved

Adding spaces between all characters in a string

Hi,

Wondered if anybody could help. I need to add spaces between all characters in strings in a column called [Names]

i.e the string 'Simon Jones', would become 'S i m o n J o n e s'

Not sure whether I am missing a simple solution. Any assistance would be much appreciated.

Thanks,

ImkeF
3 years ago
Hi C-Duff84 ,
you could add a column like so:
Text.Combine(List.Transform(Text.ToList([Names]), (l)=> l & " "), "")

Please also check the file enclosed.

Adding Spaces Between all Characters.pbix15 KB

= Table.AddColumn(Source, "Spaced", each Text.Combine(Text.ToList([Name]), " "))

4 Replies

CNENFRNL
Community Champion
3 years ago
= Table.AddColumn(Source, "Spaced", each Text.Combine(Text.ToList([Name]), " "))
- C-Duff84
  Regular Visitor
  3 years ago
  Thanks! Appreciate your support
ImkeF
Community Champion
3 years ago
Hi C-Duff84 ,
you could add a column like so:
Text.Combine(List.Transform(Text.ToList([Names]), (l)=> l & " "), "")

Please also check the file enclosed.

Adding Spaces Between all Characters.pbix15 KB
- C-Duff84
  Regular Visitor
  3 years ago
  Thanks ImkeF! Appreciate your response