Forum Discussion
Solved
Generate list with double characters
Hi there,
As titled. I wish to generate a list {M04..M10} to M04, M05, M06, M07, M08, M09, M10. Is there an function similar to List.Numbers that can help?
Isaac
Hi laui,
To achieve your requirement, you can use M code like below:
let Source = List.Numbers(4, 7, 1), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Concatenate" = Table.AddColumn(#"Converted to Table", "Concatenate Column", each if [Column1] >= 10 then "M" & Text.From([Column1]) else "M0" & Text.From([Column1])), #"Concatenate Column" = Concatenate[Concatenate Column] in #"Concatenate Column"Regards,
Jimmy Tao
1 Reply
Hi laui,
To achieve your requirement, you can use M code like below:
let Source = List.Numbers(4, 7, 1), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Concatenate" = Table.AddColumn(#"Converted to Table", "Concatenate Column", each if [Column1] >= 10 then "M" & Text.From([Column1]) else "M0" & Text.From([Column1])), #"Concatenate Column" = Concatenate[Concatenate Column] in #"Concatenate Column"Regards,
Jimmy Tao