Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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/...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    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"
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Have you tried the solution provided by MarcelBeug above? It should work in your scenario. If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. :smileyhappy:

 

Regards