Forum Discussion

kunal_mehta1's avatar
kunal_mehta1
Helper I
3 years ago
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 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.

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    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)),"/")})

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    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)),"/")})