Community Conundrum 25: Feature Visualization is now live! Read More

How to pad a number with leading zeros

How to pad a number with leading zeros

A common requirement when you have a column of numbers is to format all numbers so that they have the same length, adding leading zeros if needed.

This can be done in the DSS preparation recipe using a Formula.

The formula function to use is format. For example, to ensure that all values of the column mycolumn are padded to have a length of 11, including leading zeros, use: format("%011d", mycolumn)

Clément_Stenac_0-1585160183862.png

 

It is useful to remember the usual formula rules to refer the values of columns, as described in the DSS reference documentation

For example, to do the same in a column named "my column" (note the space), you would use instead format("%011d", numval("my column"))

format is actually a very powerful function that uses Java string formatting capabilities.  See this Java reference for more details.

Labels (3)
Version history
Revision #:
3 of 3
Last update:
‎03-30-2020 04:38 PM
Updated by: