Define A Set Of Delimiters To Split A Column

[wsnyder]

Hi all,

Using Power Query in M365.
Is it possible to define a set of delimiters to split a column?
Something like {., ?, !}

Thanks,
-w

 

[alansidman]

This should show you how-->splitting multiple delimiter in column & find max

 

[wsnyder]

Thanks alansidman,

Works perfectly!

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type","Column1",Splitter.SplitTextByAnyDelimiter({".","?","!"}))
in
    #"Split Column by Delimiter"

Thanks,
-w