Forum Discussion
Solved
How do I extract the 17-alphanumeric characters in a column, delimiter
Hello guys, I need help. How do I extract the 17-alphanumeric characters in the "name" column. I've tried different ways of extracting by delimiter but it's just not working. Name 24/1...
Download example PBIX file with the code below
= try List.Select(Text.Split([Name], " / "), each Text.Length(_) = 17){0} otherwise nullRegards
Phil
Download example PBIX file with the code below
= try List.Select(Text.Split([Name], " / "), each Text.Length(_) = 17){0} otherwise null
Regards
Phil
= Table.AddColumn(dataset, "pq", each List.Select(Text.Split([Name], " / "), each Text.Length(_) = 17 and not Text.Contains(_, " ")){0}?)
