Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
SOLVED

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

Avatar

Level 5

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @rvnth 

 

You can do something like this in enrichment.

 

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

 

 


     Manoj
     Find me on LinkedIn

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hello @rvnth 

 

You can do something like this in enrichment.

 

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

 

 


     Manoj
     Find me on LinkedIn

Avatar

Level 5

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

Avatar

Community Advisor

Hello @rvnth 

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


     Manoj
     Find me on LinkedIn