Number formatting- Adding Zeros

[santho_ak]

Hi,

I need to format number in the dimension. 

Current- Postal Code:

60051-1432

53243

60165-1232

32190-4569

54401

Required Output:

Postal Code:

60051-1432

53243-0000

60165-1232

32190-4569

54401-0000

So if the data has 9 digit Postal code then I need it as it is. Else, I would need to add '-0000' after the 5 digits. Need help. Thanks

[Kushal_Chawda · Accepted solution]

@santho_ak  try below

Postal_Code:
load *, if(index(Postal_Code,'-'),Postal_Code,Postal_Code&'-'&'0000') as Postal_Code_Formatted 
inline [
Postal_Code
60051-1432
53243
60165-1232
32190-4569
54401

[Vegar]

You could try this expression

Subfield([Postal Code], '-', 1) & '-' & alt(Subfield([Postal Code], '-', 2),'0000')