System.Format() for leading zeroes

(0) Share

Report

Posted on by EGMX

Hi everyone!

I'm trying to write a function that will take values from a table and write them to a plain text file.

In order to make the text easier to read, I'm trying to get the values in some of the columns to all be the same length. I want to achieve this by using leading zeroes.

So, let's say I want all the values to be five characters in length. If the value in the column was 99, it would be written as 00099. If it was 999, it would be written as 00999.

I understand the function System.Format() can help me achieve this, but unfortunately I haven't been able to figure out how. Does anyone know what value I have to give in the Format parameter in order to achieve this kind of result? Or maybe an alternate solution altogether?

Thanks for your time!

All responses (1)

Answers (1)

Verified answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

RE: System.Format() for leading zeroes

Hi, here are two great examples that hopefully give you some hints.

(99+) how to format quantity - Dynamics 365 Business Central Forum Community Forum

Thanks

ZHU