Forum Discussion
Solved
Add Leading Zeros within String
Hi experts!
I have a column with year and week information in this format:
Year-Week
2022-01
2023-03
2023-3
2023-5
As you can see for the week number the...
Insert this statement
= Table.ReplaceValue(Source, each [#"Year-Week"], each if Text.Length(Text.AfterDelimiter([#"Year-Week"],"-"))=1 then Text.ReplaceRange([#"Year-Week"],5,1,Text.PadStart(Text.End([#"Year-Week"],1),2,"0")) else [#"Year-Week"], Replacer.ReplaceValue,{"Year-Week"})
Hi,
you can split your column by delimiter -
then add a custom column
and merge again your column
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!