Forum Discussion

Axel_hnk's avatar
Axel_hnk
Frequent Visitor
4 years ago
Solved

Replace Leading Characters for Multiple Columns at Once

Hi there, I have always a couple of columns in my data source where the data has leading (in my case) zero. I get rid of them by: Table.TransformColumns(#"StepBefore", {{"ColumnName", each Text.Tri...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago

    Simple enough,

    = List.Accumulate({"col1","col2",..."coln"},#"Previous Step",(s,c)=>Table.TransformColumns(s, {c, each Text.TrimStart(_,"0")}))
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago

Simple enough,

= List.Accumulate({"col1","col2",..."coln"},#"Previous Step",(s,c)=>Table.TransformColumns(s, {c, each Text.TrimStart(_,"0")}))
  • Axel_hnk's avatar
    Axel_hnk
    Frequent Visitor
    4 years ago

    That's what I was looking for! Thx!