BusinessObjects Board

Regarding Account Numbers masking

hi Friends,

We are using BO 4.2 IDT SP3 with DB2 database. One of the universe objects is ‘Account Number’ whose values are displayed as shown in below format where length is not fixed (varies between 6 to 18 )

Acct Number

1234567890
1234567
123456, 567890

The requirement is to mask the account number so that it always displays last 4 digits only (with starting digits replaced by an ‘x’).
The output should look like this.

Acct Number

xxxxxx7890
xxx4567
xx3456, xx7890

In this regard, can anyone please help/suggest me how to achieve this kind of output at universe level.

Thanks,
Nova


novasuper007 (BOB member since 2010-02-25)