Forum Discussion
ashuaswinireddy
Helper I
Helper IHow 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...
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
Ashish_Mathur
Super User
Super UserHi,
How does one identify the names? i do not see a pattern there.