Forum Discussion

joooffice's avatar
joooffice
Helper I
6 years ago
Solved

Split 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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    try this:

     

    Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByAnyDelimiter({"son of","daughter of"}, QuoteStyle.Csv), {"children", "parent"})

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

try this:

 

Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByAnyDelimiter({"son of","daughter of"}, QuoteStyle.Csv), {"children", "parent"})

 

 

  • joooffice's avatar
    joooffice
    Helper I
    6 years ago

    Thanks, so obvious now you've shown me!