Forum Discussion

ashuaswinireddy's avatar
ashuaswinireddy
Icon for Helper I rankHelper I
3 years ago
Solved

How to extract name from text column

Hello All,   I have below column and would like to extract only names from below column. Highlighted names in bold in below example. Can you please let me know how to do that in power query.    C...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • CNENFRNL's avatar
    CNENFRNL
    3 years ago
    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bdBNi8IwEIDhvzL0tIIHu4KJ9bR+4aVL0cMepIfRDu1gjTBNXfLvHb8O0t4S8mZ4kv0+io1JYOU8CSTw49qmQthSUQT4ylDI+QRiMxnMYmPvHUkZNFxe2hL0/NR0sqmOkWPFno6+FdJd88+OYcdFoWXPZDtKIL0cuGYfdIXCCH864EwyhLWgO8Fc2oY+70X5UPU2VozwlRS1QF+FfpX97qr0oRl6qjvtuMtZoNRvS1aHPomZqAQ9KuSXBa+QUqW7V6mhHczg8dubJzelEh3MyX00UZ7fAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Txt = _t]),
    Extracted = Table.TransformColumns(Source, {"Txt", each Text.Combine(List.Transform(Text.Split(_,";"), each Text.BetweenDelimiters(_,": "," (",1)),"; ")})
in
    Extracted

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
3 years ago
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bdBNi8IwEIDhvzL0tIIHu4KJ9bR+4aVL0cMepIfRDu1gjTBNXfLvHb8O0t4S8mZ4kv0+io1JYOU8CSTw49qmQthSUQT4ylDI+QRiMxnMYmPvHUkZNFxe2hL0/NR0sqmOkWPFno6+FdJd88+OYcdFoWXPZDtKIL0cuGYfdIXCCH864EwyhLWgO8Fc2oY+70X5UPU2VozwlRS1QF+FfpX97qr0oRl6qjvtuMtZoNRvS1aHPomZqAQ9KuSXBa+QUqW7V6mhHczg8dubJzelEh3MyX00UZ7fAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Txt = _t]),
    Extracted = Table.TransformColumns(Source, {"Txt", each Text.Combine(List.Transform(Text.Split(_,";"), each Text.BetweenDelimiters(_,": "," (",1)),"; ")})
in
    Extracted