Mask the numbers in middle and show only first three and last four

[rvnth]

Hi Everyone, 

Is there a way to personalize the email by adding a VIP number which is a column in schema with masked something like below:

in schema , column value is actually like this 12345678432

1234******432

Thank you in advance!

[_Manoj_Kumar_ · Accepted solution]

Hello @rvnth 

You can do something like this in enrichment.

Left(ToString(@VIPNumber), 4 )+"*****"+Right(ToString(@VIPNumber), 4 )

[rvnth]

Hi @_Manoj_Kumar_ 

can I add this values inside my delivery template? I have added but then it keep saying undefined. My target mapping was recipient table inside the delivery and this column was present in a different schema. Please suggest

Best,

Revanth

[_Manoj_Kumar_]

Hello @rvnth 

Use this code in Enrichment and replace the @VIPNumber with your column.