Forum Discussion
joooffice
Helper I
Helper ISplit column by word
Hi, I have a column containing the names of parents and children merged together that i would like to split into the child and parents names. The split should come before the 'son of' or 'daughte...
try this:
Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByAnyDelimiter({"son of","daughter of"}, QuoteStyle.Csv), {"children", "parent"})
try this:
Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByAnyDelimiter({"son of","daughter of"}, QuoteStyle.Csv), {"children", "parent"})
jooofficeHelper I
Helper IThanks, so obvious now you've shown me!