Need Specific Values to the Column

[kunal_mehta1]

Hello All,

I am trying to only have the unique ID starting from 08, which is a 12 char ID. I have this column where some have a number ahead of the unique ID and some cells in that column have date after the 08 unique ID. Can i please get help for a solution, where i just need the "08" twelve digit unique id in the column and delete the other text before and after the ID.

[wdx223_Daniel · Accepted solution]

NewStep=Table.TransformColumns(PreviousStepName,{"ParentID",each let a=Splitter.SplitTextByDelimiter("08")(_) in if List.Count(a)<2 then null else Text.Combine(List.Transform(List.Skip(a),each if Text.Length(_)<10 then null else Text.Middle("08"&_,0,12)),"/")})