WJ876400Helper IV4 years agoSolvedLeading zero Hi I have a list of ID numbers and some of them are missing a leading zero, the ID number should be 8 digits long the IDs that need a leading zero are only 7 digits long. How do I add a leading z...Show Moreamitchandak to WJ8764004 years agoWJ876400 , use only one second is alternate example Text.PadStart(Text.From([Colum]),8,"0")
amitchandak to WJ8764004 years agoWJ876400 , use only one second is alternate example Text.PadStart(Text.From([Colum]),8,"0")
amitchandak to WJ8764004 years agoWJ876400 , use only one second is alternate example Text.PadStart(Text.From([Colum]),8,"0")
WJ876400Helper IV4 years agoHi amitchandak thank you for the quick response. I get an error on the custome column
amitchandakSuper User to WJ8764004 years agoWJ876400 , use only one second is alternate example Text.PadStart(Text.From([Colum]),8,"0")
amitchandakSuper User to WJ8764004 years agoWJ876400 , use only one second is alternate example Text.PadStart(Text.From([Colum]),8,"0")
Related contentLeading Zeroadding leading zerosRemove leading Zero's in QueryLeading Zero IssueVariable library usage leads to error with dynamic data destination
