Hello,

I am trying to format an integer column to have 8 characters, padded by leading zeros.
I have tried:

1. Right clicking on the column in my Data Module
2. Selecting 'Format Data'
3. Format Type = Number
4. Go To 'Advanced Options'
5. Navigate to 'Other' tab
6. Enter '0' in the Padding Character field
7. Enter '00000000' in the Pattern field

Expected: Numbers are shown with leading zeros if under 8 characters.
Actual: No changes observed to the data in the column.

I also tried creating a calculation with the following formula but received errors when evaluating:
format( column name, "00000000")

Any guidance would be much appreciated!

Best,
Sam

------------------------------
Samuel Lane
------------------------------

#CognosAnalyticswithWatson

Hi Samuel,
try something like this:
substring( '00000000'+cast (cast( COUNTRY_CODE, decimal(10)), varchar(10) ),
                     octet_length ( '00000000'+cast (cast( COUNTRY_CODE, decimal(10)), varchar(10) )) - 7,8)

//Henk

------------------------------
HENK CAZEMIER
------------------------------

Thank you for the reply Henk.  I tried your suggestion and played with it a little but could not get it to return values.

------------------------------
Samuel Lane
------------------------------

Original Message:
Sent: Fri December 06, 2019 02:17 PM
From: HENK CAZEMIER
Subject: Formatting Data Column with Pattern

Hi Samuel,
try something like this:
substring( '00000000'+cast (cast( COUNTRY_CODE, decimal(10)), varchar(10) ),
                     octet_length ( '00000000'+cast (cast( COUNTRY_CODE, decimal(10)), varchar(10) )) - 7,8)

//Henk

------------------------------
HENK CAZEMIER
------------------------------