Solved: type Text: Clean in-between white space - Page 2

michellepace · ‎09-29-2020

Hi. Is there a way to parse text to single white spaces only?

That is:

"mary white helloooo"

Becomes:

"mary white helloooo"

Anonymous · ‎10-01-2020

try this

let
    Source = Excel.Workbook(File.Contents("C:yourpath\Q.14 Data.xlsx"), null, true),
    Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Table1_Table,{{"Single space everything, and trim both ends (don’t make a new column)", type text}}),
    tc=Table.TransformColumns( #"Changed Type", {"Single space everything, and trim both ends (don’t make a new column)", each Text.Combine(List.Select(Text.Split(_," "), each _<>""), " ")})
in
    tc

View solution in original post

type Text: Clean in-between white space

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024