Hi,
I am trying to achieve an outcome similar to the example below where I want to convert a number of less than or equal to 8 digits into a string as this would be a unique identifier and needs to be concatenated with another string.
E.g. 12345 will become 00012345.
I am sure its something very simple and I have looked around but I am unable to find a solution to this.
If anyone can suggest a solution, it would extremely helpful.
Solved! Go to Solution.
Hi @PKoya,
This is the formula that you are looking for:
FieldName
PadLeft(ToString([FieldName]),8,"0")
Please mark my post as a solution if this was helpful!
Thanks, @Emil_Kos for your solution. 🙂