Forum Discussion
Remove leading Zero's in Query
Hi, I need to remove leading zeros from a character string, ideally at query level. I have seen the solution: http://community.powerbi.com/t5/Desktop/Remove-leading-zero-s-from-a-string/m-p/...
You can just choose Transform - Foormat - Trim and then adjust the generated code to have zeroes trimmed from the start.
let Source = #table({"String"},List.Zip({{"000MarcelBeug","000Ol"}})), #"Trimmed Text" = Table.TransformColumns(Source,{{"String", each Text.TrimStart(_,"0")}}) in #"Trimmed Text"
Use Columns from example if you have a column with Numbers, texts, and numbers with leading zeros.
This worked for me perfectly and was the easiest solution. Thank you