Forum Discussion
Solved
Need Specific Values to the Column
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 ...
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)),"/")})
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)),"/")})