Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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)),"/")})
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)),"/")})