Effective way to remove inner spaces in columns

[nirvana_moksh]

Hello All,

I was wondering how do you handle removing of inner spaces in a column which has values like:

USA; CHICAGO

USA:  CHICAGO

USA:     CHICAGO

In M I did a Text.Split on space and then Text.Combine, but just thinking if that is effective and the best way to handle this situation or not?

Thank You

[Greg_Deckler · Accepted solution]

    #"Replaced Value" = Table.ReplaceValue(#"Changed Type"," ","",Replacer.ReplaceText,{"Country"})

[v-chuncz-msft]

@nirvana_moksh,

By the way, you may also use SUBSTITUTE in DAX.

[nirvana_moksh]

@v-chuncz-msft - will this handle multiple space issues? Like sometimes its a double space, or three spaces or more?

[v-chuncz-msft · Accepted solution]

@nirvana_moksh,

Yes, see code below.

Column =
SUBSTITUTE ( Table1[Column1], " ", "" )

[Greg_Deckler · Accepted solution]

    #"Replaced Value" = Table.ReplaceValue(#"Changed Type"," ","",Replacer.ReplaceText,{"Country"})