Forum Discussion

stephchnva's avatar
stephchnva
Frequent Visitor
1 year ago
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...
Need Help
Omid_Motamedise's avatar
Omid_Motamedise
Super User
1 year ago

Hi stephchnva 

 

Copy the below code and paste it into the advance editor

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjLRNzTQNzIwMlHQVzD0cHf2tTAyMzZ2NDQyNjE1A4o55qRWKHjlZ+QV5+cpKMXqRCuFuRlGREZZRln6GACVmFtYAlUZmOkbGsKM8UrMzUxVCM7NLMmA6DAyUHBJTVYAShsDpV0SyzJTgBKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each List.Select(Text.Split([Name]," / "),(x)=>Text.Length(x)=17){0})
in
    #"Added Custom"